Can't connect to remote MySQL server with error 61

Question

When I tried to connect the remote MySQL server by using command line `mysql -h -u any_existing_users -p` or any other mysql client such as phpmyadmin, it didn't work and the error hint was ``` ERROR 2003 (HY000) Can't connect to MySQL server on '' (61) ``` But, when I tried `ssh ` and connected the MySQL locally by `mysql -u root -p`, there is no problem. Here is part of the user table(`SELECT User, Host FROM mysql.user;`): ``` +------------------+----------------+ | User | Host | +------------------+----------------+ | root | % | | other_users | | | root | localhost | +------------------+----------------+ ``` Here is the iptable: ``` Chain INPUT (policy ACCEPT) num target prot opt source destination 1 RH-Firewall-1-INPUT all -- 0.0.0.0/0 0.0.0.0/0 Chain FORWARD (policy ACCEPT) num target prot opt source destination 1 RH-Firewall-1-INPUT all -- 0.0.0.0/0 0.0.0.0/0 Chain OUTPUT (policy ACCEPT) num target prot opt source destination Chain R…

Accepted Answer

Check if your mysql server is listening on a socket with netstat:

```
netstat -tulpen
```

and search for 3306.

If not or if only on localhost, check my.cnf and search the `bind-address` line and change it to:

```
bind-address = 0.0.0.0
```

then restart the server and try again.

Can't connect to remote MySQL server with error 61

Solution

Problem

Related problems