转 Error No. 1130 Host '*.*.*.*' is not allowed to connect to this MySQL server
来源:互联网 发布:金蝶erp管理系统源码 编辑:程序博客网 时间:2024/06/16 08:45
出现情况:
使用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
- 转 Error No. 1130 Host '*.*.*.*' is not allowed to connect to this MySQL server
- Error No. 1130 Host '*.*.*.*' is not allowed to connect to this MySQL server解决方法
- [MySQL]MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- mysql:ERROR 1130: Host '192.168.0.102' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- mysql数据库错误ERROR 1130:Host '' is not allowed to connect to this mysql server
- MySql - SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- 解决MySQL ERROR 1130 (HY000): Host 'XXX' is not allowed to connect to this MySQL server
- MySql - SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- mysql ERROR 1130: Host ’localhost′ is not allowed to connect to this MySQL server
- 解决MySQL ERROR 1130 (HY000): Host 'XXXX' is not allowed to connect to this MySQL server
- 【mysql】ERROR 1130: Host ’...′ is not allowed to connect to this MySQL server
- ERROR 1130: Host 'A'is not allowed to connect to this MySQL server
- ERROR 1130: Host 'A'is not allowed to connect to this MySQL server
- (zt)ERROR 1130: Host '192.168.1.110' is not allowed to connect to this MySQL server
- C#小程序实现从百度摘取搜索结果
- 如果有多个参数,且参数个数不确定如何调用函数
- PC与开发板之间最简单快速的文件传输方式
- 几种查询表结构的方法
- 防止重复注册
- 转 Error No. 1130 Host '*.*.*.*' is not allowed to connect to this MySQL server
- assert用法总结
- Xilinx ISE:关于related logic和unrelated logic的问题
- 读取联系人列表
- MD5算法的Java实现
- LISTVIEW绑定数据的两种方法
- Eclipse没反应或反应慢的解决办法
- php 源码 分析
- linux裸机RedHat as5.3 as4.3 上最新KFS 0.5版本安装全过程 2010年11月 依赖库使用最新版本源码编译安装[1]