Error when trying to create mysql database

hey guys

My macbook pro 17 had to be taken back to apple beuase of a dud screen,
so have had to install from macports again.

When i attempt to create a mysql database with this:

mysql5 -u root depot_development

i get this:

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket
‘/opt/local/var/run/mysql5/mysqld.sock’ (2)

any ideas?



in your config/database.yml file, add the line

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

or whatever your mysql.sock location is

$ find / -name “mysql.sock”

should find it for you. It does a find from the root dir for the file

Good Luck