在远程连接虚拟机上的mysql时，会报错：Host ‘192.168.222.1‘ is not allowed to connect to this MySQL server
原因：
root用户只有在本机(127.0.0.1)可以登录
解决办法：
创建一个新用户，将Host字段值设为请求连接的用户IP，并为其附上权限
此时test1用户可以在任意电脑上连接并拥有的权限相当于root。
相关文章
- 09-11mysql message from server: ＂Host ‘xxx‘ is not allowed to connect to th
- 09-11java.sql.SQLException: null, message from server: "Host '192.168.126.100' is not allowed to connect to this MySQL server"
- 09-11java.sql.SQLException: null, message from server: "Host 'xxx' is not allowed to connect to this MySQL server"
- 09-11连接远程数据库时出现 SSH: expected key exchange group packet from server / 2003 - Can't connect to MySQL server on 'XXX' (10038) / 1130 - Host 'XXX' is not allowed to connect to this MySQL server
- 09-11Mysql报错java.sql.SQLException:null,message from server:"Host '27,45,38,132' is not allowed to connect
- 09-11java.sql.SQLException: null, message from server: "Host 'DESKTOP-1PCF1N3' is not allowed to connect to this MySQL server"......
- 09-11解决java.sql.SQLException: null, message from server: “Host ‘xxx’ is not allowed to connect
- 09-11Cause:java.sql.SQLException: null, message from server: "Host '192.168.222.1' is not allowed to connect to this MySQL server"