Having an Issue Connecting to DB

[hepaestus]

Hello, Can you shed any light on this? I cannot connect to my local DB with mysqlfrm. Am I doing this right? I can connect to the DB with mysql client no problem.

$ docker run --link-local-ip -it sandeepsukhani/mysql-utilities mysqlfrm --port 3306 --server=wiki:password@127.0.0.1:3306 /home/pete/Desktop/wiki/text.frm
WARNING: Using a password on the command line interface can be insecure.
Usage: mysqlfrm --server=[user[:<pass>]@host[:<port>][:<socket>]|<login-path>[:<port>][:<socket>]] [path\tbl1.frm|db:tbl.frm]

# Source on 127.0.0.1: ... 
mysqlfrm: error: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)

Thanks for any help!
P.

[sandeepsukhani]

Try adding a --network=host to your docker command. I guess the container is not able to connect to port 3306 which might be due to running on a different network.

[hepaestus]

I was able to get a new error! I changed my bind-address to 0.0.0.0 and then used the following command. I get a new error. How can I tell mysqlfrm to use default_authentication_plugin = mysql_native_password?

$ docker run --link-local-ip -it sandeepsukhani/mysql-utilities mysqlfrm --port 3306 --server=wiki:1234qwerQWER@192.168.1.35:3306 /home/pete/Desktop/wiki/text.frm
WARNING: Using a password on the command line interface can be insecure.
Usage: mysqlfrm --server=[user[:<pass>]@host[:<port>][:<socket>]|<login-path>[:<port>][:<socket>]] [path\tbl1.frm|db:tbl.frm]

mysqlfrm: error: Authentication plugin 'caching_sha2_password' is not supported
# Source on 192.168.1.35: ... 

Thanks,
P.

[hepaestus]

I have the default_authentication_plugin = mysql_native_password set in the mysqld.cnf file but it is not supporting it for mysqlfrm I think.

[hepaestus]

OK Here is my latest issue. You fix from last time seesm to have worked. and I solved the password issue. Now I have this error:

$ sudo docker run --link-local-ip -it sandeepsukhani/mysql-utilities mysqlfrm --port 3307 --user=mysql --server=wiki:password@192.168.1.35:3306 /home/pete/Desktop/wiki/text.frm
WARNING: Using a password on the command line interface can be insecure.
# Source on 192.168.1.35: ... connected.
# Spawning server with --user=mysql.
# Starting the spawned server on port 3307 ... ERROR: Cannot find location of mysqld.

I don't know if it is it talking about the external local mysql of the dockerized version of mysql? Ideas?

Thanks Again,
P.