Unable to connect from MySQL Workbench to server (System error 61)

Question

MySQL error:

Failed to Connect to MySQL at 12.34.567.890:3306 with user jsdbadmin

Lost connection to MySQL server at 'reading initial communication packet', system error: 61

Using:

Plesk, SuSE vServer, fresh installation: completly new about an half year ago.

Software:

Trying to connect via MySQL Workbench, current version.

Hostname: 12.34.567.890 (modified for privacy), also tried with domain
Port: 3306
Username: My DB user name, as specified in Plesk when DB was created.
Password: *************
Default Schema: feeds

Tried TCP/IP, TC/IP over ssh.

Searched online:

These settings are not the problem:

#skip-networking
#bind-address = 127.0.0.1

Both already commented out.

Solution

Do you have a Firewall blocking the connection ?

You can test by telneting to the mysql port.

you also need to allow the ip/user combos that are allowed to connect

e.g. to add a new user

GRANT ALL ON jsdbadmin.* TO remoteadmuser@'12.34.567.890' IDENTIFIED BY 'PASSWORD';

or to grant access to a specific ip

update db set Host='12.34.567.890' where Db='yourdatabase';
update user set Host='12.34.567.890' where user='jsdbadmin';