Trouble : I can't connect and it takes a while to obtain the following message :

«Can't connect to host Unknown MySQL server host (<server name>)(0)»

Explanation :

The machine hosting your target MySQL® server is unreachable.

Solution :

The host doesn't exist : Nothing to do ! :-)

The host exists but the DNS service doesn't know it : use the IP address instead of the fully qualified name

The host exists but the router filters the TCP Port : change it on the client and on the server

Trouble : I can't connect and i obtain the following message :

«Can't connect to MySQL server on <server name> (10061)»

Explanation :

The machine hosting your target MySQL® server exists and is reachable but the MySQL® daemon is unreachable

Solution :

The MySQL® daemon is not launched :launch it

The MySQL® daemon is launched on another TCP Port : correct the TCP Port on your WinMySQL Professional

Trouble : I can't connect and i obtain the following message :

«Can't connect to host : Access denied for user: '<username@user_station>' (Using password: YES)»

Explanation :

The current connection pair user/station doesn't have enough privileges to connect on the wanted database or

the password is invalid.

Solution :

Invalid password : restart connection with the valid password.

Not enough privileges : Grant privileges.

Trouble : When i try to connect to a database, i obtain the following message :

«Link lost»

Explanation :

The target MySQL® server is probably an old version (typically 3.21.33b-log) which doesn't support the «anticrash socket» feature.

Solution :

Just uncheck the «anticrash socket» option in the connection profile before connecting.

Trouble : I have created a user with all rights granted on a specific database with connection capability from any host (%) but access is always denied for this user :

Explanation :

You have granted the right to connect from anywhere for a specific user on a specific database, but this user could have only the right to connect from «localhost» in its general privileges, this clause overrides the «%» in the «hosts» combobox when the privilege range selector is positionned on a specific database.

Solution :

Add, for this user, a «%» in the «hosts» combobox when the range selector is positionned on the «general privileges» value.