Apply OS : Windows, Mac, Linux, iOS
Apply Navicat Product : Navicat for MySQL, Navicat for MariaDB, Navicat Premium
Apply Navicat Version no. : All
If you get the error message 'Can't connect to MySQL server on some_host', you can try the following things to find out what the problem is:
- Check whether the server is running on that host, e.g. in Windows, executing telnet some_host 3306 and pressing the Enter key a couple of times. (3306 is the default MySQL port number. Change the value if your server is listening to a different port.) If there is a MySQL server running and listening to the port, you should get a response that includes the server's version number. If you get an error such as telnet: Unable to connect to remote host: Connection refused, then there is no server running on the given port.
- If the server is running on the local host, try using mysqladmin -h localhost variables to connect using the Unix socket file. Verify the TCP/IP port number that the server is configured to listen to (it is the value of the port variable.)
- Make sure that your mysqld server was not started with the --skip-networking option. If it was, you will not be able to connect to it using TCP/IP.
- Check to make sure that there is no firewall blocking access to MySQL. Applications such as ZoneAlarm and the Windows XP personal firewall may need to be configured to allow external access to a MySQL server.
For more information, please refer to - http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html