MySQL said: Can't connect to MySQL server on '127.0.0.1' (61)
This took my quite some time to resolve. The problem in my case started when I changed the root password. Sequel Pro gave me error first so I thought it is easy, just use the new password. But that did not work. Note that only Sequel Pro was broke, My PHPMYADMIN was working fine without any trouble. What really worked for me to fix Sequel Pro connectivity, I changed two things
* Change 127.0.0.1 to localhost in connection string
* Used the old password (not the new one that I just changed)
Trouble Shoot Connection from Command Prompt
Other things you can do is, try to connect to MYSQL from command prompt in Terminal (I am on mac OS X Mavericks).
/Applications/xampp/xamppfiles/bin/mysql -u root -p # this will prompt for password
Once this connects using the correct password, you already know what is the password. Then change 127.0.0.1 to localhost (all lower case). That should probably solve it.
The following screenshot setting should connect.
Note that the following setting used to work but after I changed the password, it no longer works.
When you provide localhost, it will popup this dialog. Just select “Connect Via Socket”.
I was getting these errors while I was working on it
Password provided on command prompt was wrong.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)