Home / server / Questions / 178088
In Process
iamjonesy
Asked: 2010-09-05 06:34:40 +0800 CST

mysql problems after Mac OS X software update

  • 772

After running Mac OS X updates this morning when I run PHP projects on my local machine, when they were fine last night are now giving me errors:

mysql_connect() [function.mysql-connect]: [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) [CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 540]

Has anyone had a similar problem?

Jonesy

mysql php mac-osx

3 Answers

  1. From apple support forum : http://discussions.apple.com/thread.jspa?messageID=12176949

    I had the same problem and fixed it by editing my php.ini file:

    1. In Terminal type sudo nano /etc/php.ini (Terminal will ask you for your password)

    2. Change: mysql.default_socket = to: mysql.default_socket = /tmp/mysql.sock

    3. Press Ctrl-O, then Enter to save

    4. Still in Terminal, type sudo apachectl graceful

    5. That's it!

    • 3

  2. It appears that MySQL is no longer running. How did you install MySQL? Does it report any error when you try to start/restart it?

    • 1

  3. you can start the mysqld deamon pointing to any socket file that you want. You just have to say to the client as well which file you want to use.

    In your case i would:

    • check if the /var/mysql directory exists
    • check if your user has permission to write file on this directory

    you can try to start your deamon using a socket file like:

    mysqld_safe --socket=/tmp/mysql.sock

    and then with your mysqlclient you can do something like

    mysql -u user -p --socket=/tmp/mysql.sock

    it will work

    • 0