访问被拒绝为mysql错误 [英] Access denied for mysql-error

问题描述

我正在尝试使用我的MySQL数据库，但我似乎无法使用Toad远程连接（基于Windows的服务器与MySQL数据库）。在为SSH登录和数据库登录输入正确的凭据后，我仍然得到：

I'm giving Toad a try for use with my MySQL db, but I cannot seem to connect (windows-based server with MySQL database) remotely using Toad. After entering the right credentials for both SSH login and the database login, I still get this:

'Access denied for user 'wlp'@'---.---.--.111' (using password: YES)'

我可以直接使用SSH和MYSQL命令远程登录命令行使用相同的主机和凭据，所以我相信凭据和防火墙设置不是问题。 SSH和数据库的用户名是相同的（不是最聪明的，我知道），所以我甚至尝试在我切换凭据的情况下撤消密码条目。没有区别。



我查看了Toad的连接属性，看看它是否以某种方式加密我的凭据，这可以解释拒绝访问错误，但没有什么都看。



这必须是基本的，但我不知道我错过了什么？有任何想法吗？

谢谢。

I can however successfully login remotely using SSH and MYSQL commands directly from the command line using the same host and credentials, so I believe the credentials and firewall settings are not the problem. The username is the same for both SSH and the db (not the smartest, I know), so I even tried reversing the password entries in case I had the credentials switched. No difference.

I looked through Toad's 'Connection Properties' to see if it was encrypting my credentials somehow which could explain the 'Access denied' error, but didn't see anything.

This has to be basic, but I don't see what I'm missing? any Ideas?
Thanks.

推荐答案

您必须配置mysql以允许来自其他计算机的连接 - 默认情况下，只接受来自同一台计算机的连接。

You must configure mysql to allow connections from other computers - by default, only connections from the same machine are accepted.

您好，请看这个链接：



访问被拒绝的错误



希望有所帮助：）

Hi, see this link:

Access-Denied Errors

Hope it helps :)

这篇关于访问被拒绝为mysql错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！