message from server: "Host '192.168.1.10' is not allowed to connect to this MySQL server
来源:互联网 发布:怎么加入淘宝充值平台 编辑:程序博客网 时间:2024/06/01 08:25
在连接本机的mysql 数据库时,配置连接信息,连接发生错误,提示:message from server: "Host '192.168.1.10' is not allowed to connect to this MySQL server
但是将IP地址改为localhost又能正常连接到MySQL数据库。
临时处理方案:
1、先用localhost方式连接到MySQL数据库,然后使用MySQL自带的数据库mysql;
use mysql;
2、执行:select host from user where user = 'root'; 发现,host的值就是localhost。
所以将它的值改掉:update user set host='%' where user = 'root';
3、修改完成后,执行:flush privileges;
将修改内容生效,再次配置时,用IP地址或者localhost 就都能正常连接到MySQL数据库了。
0 0
- message from server: "Host '192.168.1.10' is not allowed to connect to this MySQL server
- message from server: "Host '192.168.1.10' is not allowed to connect to this MySQL server
- MySQL:message from server: "Host xxx is not allowed to connect to this MySQL server"
- mysql数据库 message from server: "Host is not allowed to connect to this MySQL server"解决办法
- null, 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 'xxx' 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 'XXXX' is not allowed to connect to this MySQL server"
- message from server: "Host '10.21.0.245' is not allowed to connect to this MySQL server
- message from server: "Host 'xxx' is not allowed to connect to this MySQL server的解决
- message from server: "Host '114.111.166.7' is not allowed to connect to this MySQL server"
- jdbc连接mysql时报message from server: "Host '**' is not allowed to connect to this MySQL server"错误解决
- mysql message from server: "Host 'xxx' 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 xxx 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
- 全部源代码_
- asp.NET代码转为flex代码
- 已可预见MariaDB将替代MySQL
- Compare Version Numbers
- HDUOJ 1789(贪心)
- message from server: "Host '192.168.1.10' is not allowed to connect to this MySQL server
- MySQL学习笔记
- java线程基础
- Spark核心开发者:性能超Hadoop百倍,算法实现仅有其1/10或1/100
- android_studio视频地址
- select下拉框的响应事件
- debian虚拟机+putty配置
- Cookie/Session机制详解
- ZigBee PANID 扩展PANID