Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)

by

Test

If you attempt to start MySQL using the full path it should work

/Applications/MAMP/Library/bin/mysql -u root -p

Fix

If that works, then you can set it to work normally by running

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock

Resolution

Now MySQL should work normally

mysql -u root -p

More Related Contents:

  1. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  2. Restoring deleted ‘root’ user and password for MySQL
  3. Does MySQL included with MAMP not include a config file?
  4. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  5. multiple query same table but in different columns mysql
  6. How can I make SQL case sensitive string comparison on MySQL?
  7. Import data in MySQL from a CSV file using LOAD DATA INFILE
  8. How to do a batch insert in MySQL
  9. Get current AUTO_INCREMENT value for any table
  10. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  11. Rails, MySQL and Snow Leopard
  12. MySQL CONVERT_TZ()
  13. mysql trigger stored trigger is already used by statement which invoked stored trigger
  14. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  15. mysql update query with sub query
  16. Case Sensitive collation in MySQL
  17. Mysql: Order by like?
  18. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  19. Getting first day of the week in MySql using Week No
  20. Can’t import database through phpmyadmin file size too large
  21. How to change MySQL column definition?
  22. How can I undo a mysql statement that I just executed?
  23. MySQL : how to remove double or more spaces from a string?
  24. is php sort better than mysql “order by”?
  25. Mysql returning clause equivalent
  26. How can “set timestamp” be a slow query?
  27. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  28. Migrating data into Firebase from MySQL
  29. How to escape apostrophe (a single quote) in MySql?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment