原因:虚拟机上ubuntu系统需要访问主机的mysql服务
mysql默认不允许远程服务
如果你想允许用户root从ip为192.168.2.3的主机连接到mysql服务器,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON . TO ‘root’@’192.168.2.3’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
使用通配符让所以主机都能访问
GRANT ALL PRIVILEGES ON . TO ‘root’@’*’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;