Host ‘IP’ is not allowed to connect to this MySQL server

在用Navicat远程连接Mysql数据库时遇到如下报错信息，因为当前账号不支持远程连接

1.首先在系统中登录mysql

mysql -u root -p

如果忘记登录密码，请查看
https://blog.csdn.net/qq_36543562/article/details/106824653

2.执行执行命令：

use mysql;
select host from user where user='root';
flush privileges;

3.再次使用Navicat连接MySql