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

rubyonrails-talk
1

i have a small problem every time i run "rake db:migrate" it shows me an error

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

can somebody help me?

2

hi

its possible that either the socket is already in use or the the path for the socket is false..

these r the only 2 possiblities i guess

thanks

Dhaval Parikh Software Engineer www.railshouse.com sales(AT)railshouse(DOT)com

3

Thanks for replying,

What you said is actually very usefull because i didn't know why this could be happening, can you give me any tip of how i could solve the problem?

4

Do you have any idea how i can start soliving this problem?

5

Assuming that mysql is actually installed and running,

check that what you've got in database.yml (in the socket parameter) matches what's in /etc/my.cnf If database.yml doesn't specify the socket then it's probably falling back on some default, so set it to whatever is in my.cnf

Fred

6

Awesome, thanks it's working now, I specified the socket and it's working fine