What Do I Do When I Receive a MySQL Local Connect Error?
Print this Article
Comment on this Article
Last Updated:
September 27, 2007 3:35 PM
Error Message:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/u/s/e/username/html/file.php on line 2
Cause:
This is caused by your script trying to connect to 'localhost' as the MySQL server. The error displays the exact line that needs to be altered (in this case, it is on /file.php line 2).
Resolution:
To resolve this error, change your database connection string to use the correct server name. This can be found in the MySQL section of your hosting control panel.
Incorrect Example:
mysql_connect("localhost", "username, "password");
Correct Example:
mysql_connect("mysql12.secureserver.net", "username", "password");
For more information see Choosing a Host Name for Your SQL Database.