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

Posted by on Aug 17, 2011 in News | 7 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 :)

7 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

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