mysql error1103 Host * is not allowed to connect to this MySQL server解决方法
来源:互联网 发布:微信web开发工具 mac 编辑:程序博客网 时间:2024/06/03 19:41
如果mysql不支持远程连接,会出现提示:错误代码是1130,ERROR 1130: Host * is not allowed to connect to this MySQL server。
解决方法如下:
localhost改成%
进入mysql的BIN目录
代码如下复制代码mysql -u root -p
mysql>use mysql;
mysql>update user set host =’%'where user =’root’;
mysql>flush privileges;
具体分析
1、在本机登入mysql后,更改“mysql”数据库里的“user”表里的“host”项,从”localhost”改为'%'。
代码如下复制代码mysql>mysql>use mysql;
mysql>select 'host' from user where user='root';
#查看mysql库中的user表的host值(即可进行连接访问的主机/IP名称)
代码如下复制代码mysql>update user set host = '%' where user ='root';#修改host值(以通配符%的内容增加主机/IP地址,当然也可以直接增加某个特定IP地址,如果执行update语句时出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' 错误,需要select host from user where user = 'root';
查看一下host是否已经有了%这个值,如果有了直接执行下面的flush privileges;即可)
mysql>flush privileges;
mysql>select host,user from user where user='root';
mysql>quit
0 0
- mysql error1103 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,
- Host '***' is not allowed to connect to this MySQL server
- mysql host is not allowed to connect to this mysql server 解决方法
- mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
- Host 'XXX' is not allowed to connect to this MySQL server 解决方法/开启MySQL远程账号
- mysql 远程访问不行解决方法,Host '' is not allowed to connect to this MySQL server
- mysql远程连接报错: Host * is not allowed to connect to this MySQL server,解决方法
- mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
- Friend Circles
- 线程安全和可重入函数的联系与区别
- Hibernate第七篇【对象状态、一级缓存】
- GET、POST请求区别
- KVM总结-KVM性能优化之内存优化
- mysql error1103 Host * is not allowed to connect to this MySQL server解决方法
- HDU1257
- 网站页面优化的方向及网页的设计
- 图论_最短路问题
- JPA使用指南 javax.persistence的注解配置
- 协同过滤Collaborative Filtering
- Sarsa
- PAT_1036. Boys vs Girls
- Codeforces 443D Andrey and Problem