Topic: (sorry) Rails and MySQL not getting it on
I appreciate that this is one of the more common installation pitfalls but I'm stumped!
This is my third install of Rails (each time having used a different method!) and I'm using MacPorts to setup a Rails and MySQL environment on my Apple MacBook Pro (10.4.10).
I'm following Agile Web Development With Rails (2nd Edition) and have just attempted to use the depot_development MySQL database required for the web application.
Firstly, all of the MacPorts packages installed fine (following Duncan Davidson's method as instructed by the book). I am using the root username and have created a password for this account (which I have updated database.yml to reflect).
Here is the error (I gather from other sources this is ambiguous - and I have looked in MANY other sources!):
Chimera:~/Sites/depot Lloyd$ rake db:migrate
Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)
(See full trace by running task with --trace)
To be honest I don't know what the problem could be or how to fix it!
Many thanks in advance,