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 server, it works. I don't know what happened when I am using sequel pro to connect to the server.
+2
A:
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.
lunixbochs
2010-03-15 03:50:27
thanks very much. this helps me a lot in my understanding of the current problem. but the sequel pro used to work on my laptop, this problem happened after i restarted the server. something even more weird is that my teammates can still access the mysql server even after i have restarted the server. any help?
Yang
2010-03-15 04:22:03
which computer is the server running on?
lunixbochs
2010-03-15 04:48:50
it is a internal server running mac os x.
Yang
2010-03-15 05:29:22
+1
A:
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
zerkms
2010-03-15 03:50:33
hi, zerkms, thanks very much for the help, but the sequel pro only shows the error after i restarted the server this morning. this used to work fine.
Yang
2010-03-15 04:23:24