启用远程 MySQL 连接:ERROR 1045 (28000): Access denied for user

2021-11-20 00:00:00 mysql

在 Windows XP 上运行的 MySQL 5.1.31.

MySQL 5.1.31 running on Windows XP.

从 本地 MySQL 服务器 (192.168.233.142) 我可以以 root 身份连接，如下所示:

From the local MySQL server (192.168.233.142) I can connect as root as follows:

>mysql --host=192.168.233.142 --user=root --password=redacted

从远程机器(192.168.233.163)，我可以看到mysql端口是开放的:

From a remote machine (192.168.233.163), I can see that the mysql port is open:

# telnet 192.168.233.142 3306
Trying 192.168.233.142...
Connected to 192.168.233.142 (192.168.233.142).

但是当我尝试从 远程 机器连接到 mysql 时，我收到:

But when trying to connect to mysql from the remote machine, I receive:

# mysql --host=192.168.233.142 --user=root --password=redacted
ERROR 1045 (28000): Access denied for user 'root'@'192.168.233.163' (using password: YES)

我在 mysql.user 中只有 2 个条目:

I have only 2 entries in mysql.user:

Host         User     Password
--------------------------------------
localhost    root     *blahblahblah
%            root     [same as above]

我还需要做什么才能启用远程访问?

What more do I need to do to enable remote access?

编辑

正如下面 Paulo 所建议的，我尝试将 % 的 mysql.user 条目替换为特定于 IP 的条目，因此我的用户表现在如下所示:

As suggested by Paulo below, I tried replacing the mysql.user entry for % with an IP specific entry, so my user table now looks like this:

Host             User     Password
------------------------------------------
localhost        root     *blahblahblah
192.168.233.163  root     [same as above]

然后我重新启动了机器，但问题仍然存在.

I then restarted the machine, but the problem persists.

推荐答案

Paulo 的帮助引导我找到解决方案.它是以下内容的组合:

Paulo's help lead me to the solution. It was a combination of the following:

  • 密码包含美元符号
  • 我试图从 Linux shell 进行连接

bash shell 将美元符号视为 扩展 到环境变量，所以我们需要用反斜杠转义它.顺便说一下，如果美元符号是密码的最后一个字符，我们不必这样做.

The bash shell treats the dollar sign as a special character for expansion to an environment variable, so we need to escape it with a backslash. Incidentally, we don't have to do this in the case where the dollar sign is the final character of the password.

举个例子，如果你的密码是pas$word"，从Linux bash我们必须按如下方式连接:

As an example, if your password is "pas$word", from Linux bash we must connect as follows:

# mysql --host=192.168.233.142 --user=root --password=pas\$word

相关文章