No such file or directory - /tmp/mysql.sock

Specify socket: /path/to/socket.sock in config/database.yml

production:
  adapter: mysql
  socket: /tmp/mysql.sock
  ...

Thanks! Worked like a charm!

/var/lib/mysql/mysql.sock for rpm version of MySQL.

And /var/run/mysql/mysql.sock for some others. Try running mysql_config --socket.

On Debian and Ubuntu, it's /var/run/mysqld/mysqld.sock

Shouldn't this try TCP if the socket fails? Or better yet, shouldn't it read my.cnf and get the location of the socket?

on mac os x with xampp, it's /Applications/xampp/xamppfiles/var/mysql/mysql.sock

just in case someone using it ...

On Suse 9.2, I set the following in database.yml: development:

adapter: mysql socket: /var/lib/mysql/mysql.sock

When I run: ruby script/generate scaffold Product Admin I get the following: Access denied for user: 'root@localhost' (Using password: NO)

Anyone know how I can fix this?

When I run: ruby script/generate scaffold Product Admin I get the following: Access denied for user: 'root@localhost' (Using password: NO

Answear: In your file database.yml you have to set a password for the root user if you have it set also on the mysql server.

Hi,

I got the error which has been addressed here some months before. I had read the contents given here and did the same, that is I had added socket: /var/lib/mysql/mysql.sock (I am using RPM version). But the problem has not been solved.

It is not working for me. Please help me.

Please don't use trac for support issues. Ask on the rails list or irc about this.

slip resistant shoes techno marine watches chinese silk rugs silk flower arrangement replica louis vuitton purses adidas superstar shoes prada shoes motorcycle sunglasses birkenstock shoes sale tag heur watches wholesale western boots how to waterproof boots dragon sunglasses children shoes wide womens shoes discount western boots boots for motorcycle dragon sunglasses compass watches womens harley davidson boots

I solved it thanks to the post you could find here http://rubyresponse.wordpress.com/2006/05/13/resolve-my-first-rails-problem/

Basically on debian/ubutu you should keep attention on installing mysql before rails, otherwise adding the option socket : /var/run/mysqld/mysqld.sock in database.yml could have no effects, nor adding a symbolic link to /tmp/.

I found fairly comprenshive the RoR installation procedure located https://help.ubuntu.com/community/RubyOnRails.

On Gentoo:

socket: /var/run//mysqld/mysqld.sock

for macports / darwinports on os x, it is:

/opt/local/var/run/mysql5/mysqld.sock

On Mac OS X Leopard with manually downloaded (from mysql.com) and installed MySQL, is /private/var/mysql/mysql.sock the socket file. And I think this option should be mentioned at least in comments in database.yml file.

if you are using MAMP on OS X 10.5.2 for me it is "socket: /Applications/MAMP/tmp/mysql/mysql.sock". Just another FYI.