Can't connect to remote server using MySQL Wor

问题:

I'm trying to connect to a remote database but it gives me an error that the password is wrong:

Connecting to MySQL server www.test.net... Access denied for user 'test'@'test' (using password: YES)

I know that the password is correct, as I can access to the cpanel with it, but it always gives me the same error, I even tried to change the user to one of the users on that database, but nothing seems to work

Answer

It seem this question gets a lot of viewers, so I might as well tell you what solved the problem for me:

I had to give permission to my IP from the server, so that my PC would be recognized as safe to access the DB

回答1:

Does the database allow access to the user test from the IP you are making the call to?

In the users table you specify a host from which this user can access the database. Often this may default to localhost or 127.0.0.1

回答2:

Allow access from all machines :

mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

Allow access from Machine which ip = x.y.z.t

mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'x.y.z.t' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

Example :

 GRANT ALL PRIVILEGES ON *.* TO 'admin'@'172.16.10.34' IDENTIFIED BY 'myp@$$word' WITH GRANT OPTION;

回答3:

To allow the user to make the call, you need to do

GRANT ALL PRIVILEGES ON *.* TO [e-mail]