Home > Database > Mysql Tutorial > body text

MYSQL-FRONT登录 ERROR 1130的解决办法

WBOY
Release: 2016-06-07 16:52:39
Original
1411 people have browsed it

在红旗Linux里装了mysql5.0.18 版本运行服务器。可在win2003里运行客户端(图形化界面MYSQL-FRONT)登录那台服务器,提示错误为:E

在红旗Linux里装了mysql5.0.18 版本运行服务器。

可在win2003里运行客户端(图形化界面MYSQL-FRONT)登录那台服务器,,提示错误为:

ERROR 1130: Host '10.3.69.239' is not allowed to connect to this MySQL server

为什么不允许win2003客户端连接MYSQL服务器呢?

问题解决方法:
首先使用update把mysql.user中的root的host从localhost修改成%:

mysql> UPDATE mysql.user SET Host='%' WHERE Host='localhost';
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%";
mysql> FLUSH PRIVILEGES;

再次连接,显示成功。

linux

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!