Problem connecting MySQL to Rails

Question

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have a Rails application and I am getting this error. I have no idea how to find mysql connect it to mysql.sock. I am pretty sure i can go into config/database.yml and set the mysql.sock but where is it or do I need to reinstall it?

When I do locate mysql i get alot of results including the two below

/usr/include/mysql
/usr/bin/mysql

but when I locate mysql.sock I get nothing

Doon · Accepted Answer · 2010-08-06 13:57:53Z

2

Is mysql actually running, and set to listen on the socket interface. Make sure that the server is started/configured.

well first check to see if it is running

ps auxwww | grep mysql

should do that, if not, then

/etc/init.d/mysql start

or

service mysql start

as root (or via sudo, should start it). but if it is running the socket should be in

/var/run/mysqld/mysqld.sock

edited Aug 6, 2010 at 13:57

answered Aug 6, 2010 at 13:14

Doon

20.3k3 gold badges42 silver badges44 bronze badges

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

1 Comment

Doon Over a year ago

well first check to see if it is running (ps auxwww | grep mysql) should do that, if not, then /etc/init.d/mysql start as root (or via sudo, should start it). but if it is running the socket should be in /var/run/mysqld/mysqld.sock

Collectives™ on Stack Overflow

Problem connecting MySQL to Rails

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related