Rake Migration Problem

I am using RailsLive CD that has PC Linux OS. I am able to bring up the MySQL server. I can create databases. But when I run Rake migration task, I get: rake aborted! Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock error message.

I also tried the AWDWR suggestion and included: socket: /var/lib/mysql/mysql.sock

in the database.yml file

I get the same error. There is no mysql.sock file in /var/lib/mysql/ directory. Can someone please help? TIA.

I am using RailsLive CD that has PC Linux OS. I am able to bring up the MySQL server. I can create databases. But when I run Rake migration task, I get: rake aborted! Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock error message.

I also tried the AWDWR suggestion and included: socket: /var/lib/mysql/mysql.sock in the database.yml file I get the same error. There is no mysql.sock file in /var/lib/mysql/ directory. Can someone please help? TIA.

Thanks for the suggestion. When I type lsof, it says that it’s not a command. ls | grep mysql.sock does not return anything.