access denied for user root, mysql database

when i am using sequel pro to connect to a remote database, the server says access denied. I am 100% percent sure that the username and password are correct. I also try to use phpmyadmin to connect to the se开发者_如何学JAVArver, it works. I don't know what happened when I am using sequel pro to connect to the server.

mysql authentication depends not only of login + password but of host too. create another user with login "root" and any password you want and necessary (or any "%") host

Your MySQL server probably only allows root logins on localhost, as I believe is default.

Since phpMyAdmin is bouncing the connection through a webserver running on the SQL server, the root connection will appear to be coming from localhost and be accepted.

I had the same problem, and the servers table was already there. Turned out sequel pro needed to have the socket url specified.

So log in to terminal in mysql:

mysql -u root

Then get mysql status by typing \s

Find what your UNIX socket path is, copy that and paste to the "socket" field in Sequel Pro.

That did it for me.