mac环境下r远程连接mysql,无法在Mac上使用MySQL Workbench连接到远程服务器

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

解决方案

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