想在本机连接虚拟机上的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