远程连接MYSQL提示Host is not allowed to connect to this MySQL server

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

2.ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'

3.linux mysql 查看默认端口号和修改端口号