CODEWITHSUNDEEP
mysqlmysql-workbenchworkbench
Ricardo Alves
Ricardo Alves

Reputation: 652

Can't connect to remote server using MySQL Workbench on mac

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

Upvotes: 3

Views: 7052

Answers (3)

Abdennour TOUMI
Abdennour TOUMI

Reputation: 93163

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;

Upvotes: 1

Patrick Demers
Patrick Demers

Reputation: 93

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

GRANT ALL PRIVILEGES ON *.* TO [email protected]

Upvotes: 0

Daniel Procter
Daniel Procter

Reputation: 188

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

Upvotes: 3

Related Questions