Today I started messing around with Rails again, after having spent the best part of the last months on Merb.

Anyway the common link problem for the mysql adapter reared its ugly head as usual.
No such file or directory - /tmp/mysql.sock

The solution to this is to create a symbolic link from your mysqld.sock to /tmp/mysql.sock

But where is your mysqld.sock?

For Mac OSX it is usually in /opt/local/var/run/mysql5/mysqld.sock.
Check where it is with locate.

locate mysqld.sock

Now create the symlink:
ln -s /link/to/where/mysqld.sock /tmp/mysql.sock
on my Mac, I ran:
ln -s /opt/local/var/run/mysql5/mysqld.sock /tmp/mysql.sock

Tags: mysql, Ruby On Rails, socket, symlink

This entry was posted on Sunday, August 10th, 2008 at 5:59 pm and is filed under Ruby On Rails. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.