Search code examples
mysqlsqlmysql-error-1045

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 server, it works. I don't know what happened when I am using sequel pro to connect to the server.


Solution

  • 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