ERROR: index 'test1': sql_connect: Host 'maoyt3' is not allowed to connect to this MySQL server (DSN
来源:互联网 发布:网络游戏优化器 编辑:程序博客网 时间:2024/06/04 19:56
方法:在本机登入mysql后,更改“mysql”数据库里的“user”表里的“host”项,从”localhost”改为'%'。
mysql>
mysql>use mysql;mysql>select 'host' from user where user='root';
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;即可)
0 0
- ERROR: index 'test1': sql_connect: Host 'maoyt3' is not allowed to connect to this MySQL server (DSN
- 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]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
- Codeforces Round #316 (Div. 2) E dp
- CodeForces Gym 100114C
- android studio string:
- JAVA虚拟机:JVM内存分区及用途
- 我的个人主页开张了,欢迎访问
- ERROR: index 'test1': sql_connect: Host 'maoyt3' is not allowed to connect to this MySQL server (DSN
- spoj Substrings【后缀自动机】
- IntelliJ IDEA 2016 破解
- DialogFragment笔记-调用广播通知界面更新
- removeFromParent 和 addChild 和引用计数的关系
- python 生成列表
- UVA 1626 Brackets sequence
- HDU 4499
- Java中关于装饰者模式的几点想法