mysql problems after Mac OS X software update

Question

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

Answer 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!

---

Answer 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?

Answer 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