mysql client gives no output when trying to connect to a remote DB

Question

I am trying to connect from a Raspbian shell to a remote MySQL database (Windows).

I freshly installed mysql-client and mysql-server (version 5.5.55) and now try following command:

mysql -v -h hostname -uroot -pmypass db_name

I get no response at all. Program does not exit or print anything just keeps hanging.

Connecting to a local DB works fine with mysql -uroot -pmypass.

I am quite confused why the client does not print anything even with the verbose option being set on.

Thanks!

Check your my.cnf. make sure bind-address variable is comment and make sure 3306 port is open. — HamoonDBA, Jul 1, 2017 at 11:34
Commenting bind-address property helped, I started getting responses from the client. Thank you! — Andrej, Jul 1, 2017 at 12:26

joanolo · Accepted Answer · 2017-07-01 12:55:44Z

2

Check your my.cnf settings. Make sure the bind-address variable is commented or its value is 0.0.0.0

Make sure port 3306 (MySQL Default Port) is open (Both on the server and on the client).

joanolo

13.3k7 gold badges35 silver badges65 bronze badges

answered Jul 1, 2017 at 12:48

HamoonDBA

6174 silver badges10 bronze badges

Add a comment |

Abishek Stephen · Accepted Answer · 2020-08-24 18:19:35Z

I had the same issue and most of the solutions given are:

But in my case, the database was hosted on a remote server and the router required port forwarding.

Hope it helps.

2 Answers 2