Apply OS: Windows, macOS, Linux, iOS

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

 

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:

  1. 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.
  2. 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.)
  3. 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.
  4. Check to make sure that there is no firewall blocking access to MySQL. Applications and the OS personal firewall may need to be configured to allow external access to a MySQL server.

For more information, please refer to - https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html

Have more questions?
Submit Ticket