SQL Error (1130): Host IP is not allowed to connect to this MySQL server
来源:互联网 发布:mac版office官网 编辑:程序博客网 时间:2024/06/06 00:17
通过HeidiSQL连接MYSQL数据库报错:
SQL Error (1130): Host ‘192.168.1.100’ is not allowed to connect to this MySQL server
说明所连接的用户帐号没有远程连接的权限,只能在本机(localhost)登录。
需更改 mysql 数据库里的 user表里的 host项
把localhost改称%
首先按下面的步骤登录Mysql服务器
登录mysql需要切换到dos下的mysql的bin目录,进行如下操作:
mysql>use mysql;
mysql>update user set host = ‘%’ where user =’root’;
mysql>flush privileges;
mysql>select ‘host’,’user’ from user where user=’root’;
mysql>quit
OK。远程连接成功!
阅读全文
0 0
- MySql - SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- MySql - SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- mysql不允许其他ip连接 MySql - SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.126' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.126' 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 远程连接错误:1130-host IP 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
- 高水位线和全表扫描
- 1.Sublime Text2 多行编辑快捷键
- 关于前端代码重构注意的几个点
- mfc 怎样动态设置static text 的可见属性
- Redis 深研究
- SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- printf
- 计算机图形学之光线跟踪算法的研究与实现2017年我的优秀毕业论文
- LDA(线性判别分析或称Fisher线性判别),PCA(主成份分析)代码及表情识别中的应用
- xcode c/c++开发
- 阿里面试回来,想和Java程序员谈一谈
- linux查看日志文件内容命令tail、cat、tac、head、echo
- BGARefreshLayout 瀑布流没到滑动到第一个就下拉刷新的bug
- 关于GC常用算法的研究