The most common error in mysql server is "Can't connect to MySQL server on 'localhost' (10061)", this happen when you attempt to connect to the MySQL database Server.

This message is generated by MySQL Database server for many reasons by :

Causes

1. MySQL Database Server (mysqld) is not running. Check your operating system's process list to ensure the mysqld process is present.

2. The port number might be different in your setup.

3. You are running on a system that uses MIT-pthreads. If you are running on a system that doesn't have native threads, mysqld uses the MIT-pthreads package.

4. You are using Linux and one server thread has died (dumped core). In this case, you must kill the other mysqld threads (for example, with kill or with the mysql_zap script) before you can restart the MySQL server.

5. The server or client program might not have the proper access privileges for the directory that holds the Unix socket file or the socket file itself.

Solutions

1. Check whether the server is running on that host by 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.

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 such as ZoneAlarm and the Windows XP personal firewall may need to be configured to allow external access to a MySQL server.