Can't Connect to MySQL Server

[marcus_green]

MySQL user can connect to mysqld Server in 2 ways -

a) The first way would be using a Unix socket file through a file in the filesystem / TCP/IP whicj is connected through a port number.

b) It is running on Windows 9x or Windows Me, the only option would be TCP/IP and if it runs on Windows NT, 2000, XP, or 2003 and starts with --enable-named-pipe option which can also connect with name pipes if running the user on the host where the server has been running.


Can't Connect to <a href="http://www.bodhost.com/ " target="_blank" title=" MySQL Server" style="color:#000000;text-decoration:none;">MySQL Server </a> refer to "no MySQL Server on the system and the admin is making use of wrong Unix Socket Filename / TCP/IP port number when it connects to the server.

Error (2003) Can't connect to MySQL server on 'server' refers to that the connection of the network has been rejected. In this case, there should be a case to check the MySQL Server and also to check if the network has been enabled, TCP/IP port is not blocked by a firewall/port blocking service.


This can be done by checking if a server process (mysqld) is running on the host server. If it is not running, then the server should be restarted and if it is then the following command should be inputed - host_ip (this shows the IP of the machine where the server is in process).