Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in

by

For some reason mysql on OS X gets the locations of the required socket file a bit wrong, but thankfully the solution is as simple as setting up a symbolic link.

You may have a socket (appearing as a zero length file) as /tmp/mysql.sock or /var/mysql/mysql.sock, but one or more apps is looking in the other location for it. Find out with this command:

ls -l /tmp/mysql.sock /var/mysql/mysql.sock

Rather than move the socket, edit config files, and have to remember to keep edited files local and away from servers where the paths are correct, simply create a symbolic link so your Mac finds the required socket, even when it’s looking in the wrong place!

If you have /tmp/mysql.sock but no /var/mysql/mysql.sock then…

cd /var 
sudo mkdir mysql
sudo chmod 755 mysql
cd mysql
sudo ln -s /tmp/mysql.sock mysql.sock

If you have /var/mysql/mysql.sock but no /tmp/mysql.sock then…

cd /tmp
ln -s /var/mysql/mysql.sock mysql.sock

You will need permissions to create the directory and link, so just prefix the commands above with sudo if necessary.

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. which is better every user have a table or just a row [closed]
  3. save user images in MYSQL database by which method? [closed]
  4. PHP – Change value y,n in database [closed]
  5. PDOException SQLSTATE[HY000] [2002] No such file or directory
  6. Many-to-many relationships examples
  7. PDO get the last ID inserted
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. How to upload images into MySQL database using PHP code
  10. PDO mysql: How to know if insert was successful
  11. How to loop through a mysql result set
  12. MySQL check if a table exists without throwing an exception
  13. Maximum execution time in phpMyadmin
  14. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  15. Fetching single row, single column with PDO
  16. Mysql No connection could be made because the target machine actively refused it
  17. Replacing mysql_* functions with PDO and prepared statements
  18. Is there any way to check the performance of mysql Indexing
  19. IP address storing in MySQL database using PHP [duplicate]
  20. Selecting a float in MySQL
  21. phpmyadmin automatic logout time
  22. MySQL skipping first row
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Fatal error: Call to undefined function mysqli_result()
  25. Laravel nested relationships
  26. Selecting all fields except only one field in mysql [duplicate]
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. mysql injection damages?
  29. How do I save PHP session data to a database instead of in the file system?
  30. Mysqli multiple row insert, simple multi insert query [duplicate]

Leave a Comment