Rails: Can't connect to local MySQL server through socket

Question

I run Ubuntu using VirtualBox on Windows 7.

When I launch "localhost:3000" (after I ran rails s), I got the following error:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed XAMPP on Ubuntu, so my MySQL installation seems to be here: /opt/lampp/var/mysql (mysql.sock is there)

How should I connect my rails application to this MySQL installation ?

Misha Moroshko · Accepted Answer · 2011-11-08 04:41:17Z

5

try the socket param in your database.yml (it defaults to /tmp/mysql.sock I think)

development:
adapter: mysql
encoding: utf8
database: yourapp_development
username: youruser
password: yourpassword
socket: /opt/lampp/var/mysql/mysql.sock

edited Nov 8, 2011 at 4:41

Misha Moroshko

172k231 gold badges521 silver badges762 bronze badges

answered Nov 8, 2011 at 4:28

sbeam

4,9127 gold badges36 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails: Can't connect to local MySQL server through socket

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related