远程连接MYSQL提示Host is not allowed to connect to this MySQL server
来源:互联网 发布:聚划算淘宝商城手表 编辑:程序博客网 时间:2024/06/05 06:53
1.使用Navicat远程连接数据库时,提示如下错误:
2.经查询是由于当前root账号的host默认为localhost。所以修改数据库中user = root 的host为%即可。
修改方法:
1.登录mysql服务器。更换数据库,使用名为mysql的数据库。
2.将user = root的host从localhost更新为%。可以选择刷新的方式让修改生效,也可以选择重启MySQL服务方式让修改生效。
PS:flush privileges;命令本质上的作用是将当前user和privilige表中的用户信息/权限设置从mysql库(MySQL内置数据库)中提取到内存里。MySQL用户数据和权限有修改后,希望在”不重启MySQL服务”的情况下直接生效,那么就需要执行这个命令。通常是在修改ROOT账号的设置后,怕重启后无法再登录进来,那么直接flush之后就可以查看权限设置是否生效。而不必冒太大的风险。
阅读全文
0 0
- 远程连接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
- 远程连接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
- 远程连接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
- 远程连接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
- 远程连接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
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- 远程连接MySQL数据库提示错误Host is not allowed to connect this MySQL server
- Mysql 远程连接错误:1130-host IP is not allowed to connect to this MySql server
- Spring事务管理只对出现运行期异常进行回滚
- java NIO Channel 学习总结
- fprintf用法解析
- Android 软键盘的显示和隐藏
- Linux与网络
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- 漫画:什么是单例模式?(整合版)
- 十进制转换成字符串
- vue单页应用之创建和运行
- 基于Drools决策表的通用规则集设计
- Android 还可以走多久?
- 【LLVM】《Getting Started with LLVM Core Libararies》读书笔记——写一个PASS
- u-boot与linux下网卡MAC地址的更改
- Java多线程编程总结