Host '*.*.*.*' is not allowed to connect to this MySQL server 解决办法
来源:互联网 发布:外置dvd刻录机 知乎 编辑:程序博客网 时间:2024/05/01 17:46
出现情况:
使用mysql的客户端SQLyog Enterprise连接到mysql的服务端时,出现如下错误:
Error No. 1130
Host '*.*.*.*' is not allowed to connect to this MySQL server
原因:
这是由于mysql服务端root用户所对应的客户端权限设置问题。默认所对应的客户端地址只有localhost(也就是服务端的机器),所以要增加相应的地址。此处,我们增加任何地址都可以访问mysql服务端的root用户。
解决办法:
# mysql
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
mysql> flush privileges;
mysql> exit
使用mysql的客户端SQLyog Enterprise连接到mysql的服务端时,出现如下错误:
Error No. 1130
Host '*.*.*.*' is not allowed to connect to this MySQL server
原因:
这是由于mysql服务端root用户所对应的客户端权限设置问题。默认所对应的客户端地址只有localhost(也就是服务端的机器),所以要增加相应的地址。此处,我们增加任何地址都可以访问mysql服务端的root用户。
解决办法:
# mysql
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
mysql> flush privileges;
mysql> exit
- host is not allowed to connect to this MySQL server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host * is not allowed to connect to this MySQL server
- host is not allowed to connect to this MySql server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host '***' is not allowed to connect to this MySQL server"
- host ... is not allowed to connect to this MySql server
- Host is not allowed to connect to this mysql server,
- Host '***' is not allowed to connect to this MySQL server
- mysql数据库 message from server: "Host is not allowed to connect to this MySQL server"解决办法
- message from server: "Host is not allowed to connect to this MySQL server"解决办法
- message from server: "Host is not allowed to connect to this MySQL server"解决办法
- mysql不能远程连接解决办法(Host is not allowed to connect to this MySQL server)
- Host '*.*.*.*' is not allowed to connect to this MySQL server 解决办法
- ERROR 1130 (HY000): Host 'xxxxxx' is not allowed to connect to this MySQL server解决办法
- "Host 'localhost' is not allowed to connect to this MySQL server" 的原因及解决办法
- SAP产品成本计算流程
- android wifi之 AsyncChannel类消息通道
- 性能测试知多少系列(目录)
- vector容器与iterator迭代器-C++
- 创建sql数据库复制的发布、订阅的问题处理
- Host '*.*.*.*' is not allowed to connect to this MySQL server 解决办法
- 杯具!!!!
- 断点的QQ伤感空间日志分享:止不住的泪,止不住的伤
- 分享Entity Framework4.1+MVC3+Jquery EasyUI的DEMO
- XCode文档注释
- Java & Android 多线程
- 思杰硬件服务的说明
- Unity脚本编绎
- Core data 框架