启用远程MySQL连接:错误1045(28000):用户被拒绝访问 [英] Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user

问题描述

在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所建议的那样，我尝试用IP特定条目替换％的mysql.user条目，所以我的用户表现在看起来像这样:

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外壳将美元符号视为

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

这篇关于启用远程MySQL连接:错误1045(28000):用户被拒绝访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！