What do I do when I receive MySQL local connect error?
This article only applies to Web & Classic Hosting. For more information, see What type of hosting account do I have?
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.