Sometimes we needed to connect to ours mysql from a program as navicat and we were that it shows a connection failure to us.
2003: Can't connect to MySQL server on €˜localhost€™ (10061)
It can be that we have put some bad data, but not always he is this and he is the servant who rejects the connection because the remote connection to mysql is not qualified.
In order to solve this, we will make the following thing:
1: To enter through ssh
To enter through SSH the Dedicated Servant or VPS
2 - To qualify Networking
Once connected you need to publish the configuration file my.cfg.
In CentOS the file is in /etc/my.cnf
3 - Once opened the file, it looks for the line that mysqld says 
To comment the line skip-networking or to clear it and to add the following one
bind-address = SU-SERVER-IP
For example, if your servant has the IP 100.100.100.100 then quedaria something
similar to this:
port = 3306
bind-address = 100.100.100.100
4 - To keep and to close the file and to reinitiate the service mysql.