错误 1130: Host '***.***.***.***' is not allowed to connect to this MySQL
来源:互联网 发布:北京赛车计划软件 编辑:程序博客网 时间:2024/06/04 00:26
在虚拟机Linux安装了mysql软件,打算在windows使用Navicat管理,连接的时候,报错。
我主要遇到两个问题,一个是防火墙,二是is not allowed to connect to this MySQL错误。
第一,开启3306端口,这个请参考我的文章CentOS 配置防火墙操作 配置端口
第二,在Linux打开数据库。
mysql>use mysql;mysql>show tables; (确认一下表user是否存在)mysql>update user set host='%' where user='root';// 会提示错误,但是没关系mysql>quit
退出mysql
重启一下mysql服务
这样在使用Navicat就可以连接mysql数据库了。
现在如果在Linux登录mysql就看不到mysql这个数据库了,需要通过Navicat修改一下mysql数据库user表数据
修改后
再重启一下mysql服务,就可以了。
0 0
- Mysql 远程连接错误:1130-host IP is not allowed to connect to this MySql server
- mysql数据库错误ERROR 1130:Host '' is not allowed to connect to this mysql server
- mysql 1130错误,host ... is not allowed to connect to this MySql server
- 远程MYSQL 1103错误 ERROR 1130: Host *.*.*.* is not allowed to connect to this MySQL
- mysql远程连接错误1130-host ... is not allowed to connect to this MySql server
- mysql 1130错误 Host '127.0.0.1' is not allowed to connect to this
- 错误 1130: Host '***.***.***.***' is not allowed to connect to this MySQL
- host is not allowed to connect to this MySQL server
- host is not allowed to connect to this MySQL
- 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
- 数据结构与算法——图
- android DecimalFormat的用法介绍
- Robotium 使用
- 图解Java单例模式内存分配
- Hello博客
- 错误 1130: Host '***.***.***.***' is not allowed to connect to this MySQL
- messagepack 初试
- 解决Xcode7.1上传成功但iTunesconnect一直不能构建版本的问题
- 解决OracleRAC集群下创建SDE时报Stored procedures错误问题
- android Animation 动画效果收集
- No location, value may have been optimized out
- Centos 7 学习之静态IP设置
- 内联函数
- [转]写给新手程序员的一封信