问题:
虚拟机192.168.211.101连接在192.168.211.2(宿主机)上的mysql报错:
java.sql.SQLException: null, message from server: "Host '192.168.211.101' is not allowed to connect to this MySQL server"
解决方案:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.211.101' IDENTIFIED BY 'xxx' WITH GRANT OPTION;
效果:
在mysql.user表中添加了一条记录
参考:远程连接mysql时,提示“is not allowed to connect to this MySQL server”的解决方法