Fixing the “unix:///var/mysql/mysql.sock” not found error on MAMP

Posted by on Aug 17, 2011 in News | 32 comments

Fixing the “unix:///var/mysql/mysql.sock” not found error on MAMP

I’ve recently been working on a CakePHP project on my Mac, I’ve noticed that when
I tried Baking the project, This error came out:

Warning Error: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in [/Users/xxxxx/Projects/public_html/xxxxxx/lib/Cake/Model/Datasource/Database/Mysql.php, line 157]

After a lookup, seems lots of people seem to come through this when working on MAMP
so to fix that, start your terminal and create a link to “mysql.sock” manually

sudo mkdir /var/mysql

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

 

Now go back and have a happy bake :)

32 Comments

  1. JDR | August 22, 2011 at 10:31 pm

    Thanks a lot!

    I was trying to run many php files from the command line and didn’t know the reason why it was showing up some errors when sql statements were run. It took me days until I found out your simple but smart solution. :)

    I assume that php is looking for a path that would be by default if mysql was installed individually and not as part of MAMP as it was my case. Linking a new folder with the active one used by MAMP is a great idea.

    Reply
  2. 3cents | December 6, 2011 at 1:49 am

    thanks a lot !!!

    Reply
  3. Octavian | December 10, 2011 at 1:47 pm

    Thanks a million man!

    Reply
  4. Frank | December 16, 2011 at 1:20 am

    Thanks Berg! much appreciated.

    Reply
  5. Bruno | December 28, 2011 at 4:56 pm

    oh man, thanks mate…. 1 command and you solved 2 days of arguments… :)
    Thanks a lot

    Reply
  6. Guins | January 17, 2012 at 10:31 pm

    Thanks a lot, first search on facebook, just perfect !

    Reply
  7. Ilie Pandia | March 4, 2012 at 11:34 pm

    Hello,

    Instead of creating a link I think is better to configure the location of the socket in php.ini

    Open the php.ini you’re using with MAMP, look for [Pdo_mysql] and right under that you should find a line like this:

    pdo_mysql.default_socket=/var/mysql/mysql.sock

    Comment out that line (if not commented already) and then add the new location of the mysql.sock

    pdo_mysql.default_socket=/Applications/MAMP/tmp/mysql/mysql.sock

    Note: If do NOT use MAMP the most likely location on Mac for mysql.sock is /tmp/mysql.sock

    Reply
  8. Ilie Pandia | March 4, 2012 at 11:42 pm

    I forgot to add that you need to restart you Apache server to pick up the change in php.ini otherwise it won’t work :)

    Reply
  9. Sam | March 5, 2012 at 2:50 am

    I love you so much! I have been searching on how to fix this for a long bloody time!
    Much appreciated.

    Reply
  10. Ibrahim Azhar Armar | March 10, 2012 at 2:59 pm

    I had problem using Doctrine CLI with Doctrine framework and gave me similar error message. thanks mate that command solved my problem

    Reply
  11. Ibrahim Azhar Armar | March 10, 2012 at 3:00 pm

    I had problem using Doctrine CLI with Zend framework and gave me similar error message. thanks mate that command solved my problem

    Reply
  12. Vick | April 3, 2012 at 12:00 am

    You are a genius, thanks mate!

    Reply
  13. Tamil | April 4, 2012 at 10:47 am

    Thank You very much

    Reply
  14. Fiqri | April 23, 2012 at 8:39 am

    Thanks a lot , saved me loads of time :)

    Reply
  15. Gippy | May 17, 2012 at 9:19 pm

    Watch out … the Apple security update can wipe out the link

    Reply
  16. Paulo Rodrigues | May 20, 2012 at 2:10 am

    Thanks a lot! :)

    Reply
  17. John Erck | June 27, 2012 at 7:08 pm

    Thanks.

    Reply
  18. Ryan | July 1, 2012 at 5:15 am

    Thanks for this. Got to love the simple fixes.

    Reply
  19. Germano | July 16, 2012 at 5:56 pm

    Thanks!!!

    Very usefull!!

    Reply
  20. Mo | September 13, 2012 at 11:19 pm

    WOW that was easy!

    Reply
  21. Anonymous | October 7, 2012 at 4:55 pm

    Thanks a lot :) Helped so much !

    Reply
  22. MidnightFistFight | October 11, 2012 at 4:45 am

    Man — I just spent the past three hours of my life trying to find the solution to this problem. Fixed me right uP!

    Reply
  23. houssem | October 15, 2012 at 8:26 pm

    thank you ! :)

    Reply
  24. Dodg3r | February 5, 2013 at 10:49 pm

    Thanks mate. Exactly what i was looking for :)

    Reply
  25. Peter Iwanwitsch | March 1, 2013 at 8:41 am

    Thanks. Nice post …

    Reply
  26. mohammed | April 3, 2013 at 11:25 pm

    Legend!!!!!

    Reply
  27. Marc | April 9, 2013 at 10:56 pm

    Very nice, thanks!

    Reply
  28. Neokio | May 23, 2013 at 5:17 am

    Thank you FTW!!!

    Reply
  29. hiroyuki kiyomizu | June 7, 2013 at 6:20 am

    thanks a lot !!!
    Good job

    Reply
  30. Rana | June 13, 2013 at 7:03 am

    Thanks a lot. You saved my day :D

    Reply

Trackbacks/Pingbacks

  1. I’ve been having problems hooking CakePHP into MAMP… « « Jay Margalus Jay Margalus - [...] http://www.mostafaberg.com/2011/08/fixing-the-unixvarmysqlmysql-sock-not-found-error-on-mamp/   [...]
  2. Scheduled Tasks in SilverStripe | Deadly Technology - [...] “unix:///var/mysql/mysql.sock” not found My task could not connect to the database, because the mysql.sock file could not be found. ...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>