无法在Mac上使用MySQL Workbench连接到远程服务器 [英] 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:

连接到MySQL服务器www.test.net ...用户被拒绝访问 'test'@'test'(使用密码:是)

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

我知道密码是正确的，因为我可以使用它来访问cpanel，但是它总是给我同样的错误，我什至试图将用户更改为该数据库上的一个用户，但是似乎什么也没有工作

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

答案

这个问题似乎吸引了很多观众，所以我不妨告诉您是什么为我解决了这个问题:

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

我必须从服务器授予我的IP许可，这样我的PC才可以安全访问数据库

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

推荐答案

数据库是否允许从您正在调用的IP上访问用户测试?

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

在用户"表中，您指定该用户可以从中访问数据库的主机.通常，这可能默认为localhost或127.0.0.1

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

这篇关于无法在Mac上使用MySQL Workbench连接到远程服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！