远程连接MYSQL提示Host is not allowed to connect to this MySQL server
来源:互联网 发布:全世界讨厌中国人知乎 编辑:程序博客网 时间:2024/06/04 18:31
想在本机连接虚拟机上的mysql时,出现host id not allowed to connect to this MySQL server错误,经查询,采用如下方法修改:
改表法:可能是账号不允许从远程登录,只能在localhost,此时需在localhost那台电脑登入mysql后,更改'mysql'数据库里的'user'表中的'host'项,从'localhost'改成'%',如下步骤:
mysql -u root -p
yourpassword
mysql>use mysql;
mysql>update user set host='%' where user='root';
注:如果此时报Duplicate entry '%-root' for key 'PRIMARY'错时,不予理会即可
mysql>flush privileges;
重新远程连接就Ok了
参考:1.远程连接MYSQL提示Host is not allowed to connect to this MySQL server
2.ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
3.linux mysql 查看默认端口号和修改端口号
阅读全文
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
- studio3.0Butterknife使用及报错解决
- Java中的transient关键字
- servlet 和 filter执行顺序
- 深入理解Java垃圾回收机制
- 生成器方法Symbol.iterator
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- 关于拷贝文件后的权限问题
- selenium的下载地址
- cocos creator 系统事件监听方法
- 头像上传代码
- 【我的Java笔记】多线程安全问题 & 同步机制
- HtmlAgilityPack官方文档(一)【Parser】
- 蓝桥杯-考察团组成
- postDelayed(Runnable runnable ,long delayMillis)只执行一次