That seems to be a common problem. I fixed it a while back searching for it in Google.

Just search for the whole thing in Google: "Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock'"