1:修改mysql库中的user表的root用户的host值为%
2:授权:在mysql命令中执行
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY 密码 WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY‘123456‘ WITH GRANT OPTION;
3:在执行命令:flush privileges;刷新权限
连接虚机中的mysql服务
原文:http://www.cnblogs.com/feiyun126/p/7268626.html