message from server: “Host is not allowed to connect to this MySQL server“问题的解决办法

数据库安装完成后，默认是不能远程登陆的，只能在本地用localhost 或者127.0.0.1登录访问，如果需要远程登录，则需要修改mysql设置，具体修改方式：

本地登录mysql： 

[root@localhost ~]$ mysql -u root -p123456

查看数据库中mysql表中的权限设置：

mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select host, user from user;+-----------+---------------+| host      | user          |+-----------+---------------+| localhost | mysql.session || localhost | mysql.sys     || localhost | root          |+-----------+---------------+3 rows in set (0.00 sec)

修改root用户权限：

mysql> update user set host = ‘%’ where user = ‘root’;

此时，root用户的权限已经允许非localhost登录

mysql> select host, user from user;+-----------+---------------+| host      | user          |+-----------+---------------+| %         | root          || localhost | mysql.session || localhost | mysql.sys     |+-----------+---------------+3 rows in set (0.00 sec)

最后，刷新设置，即可远程登录

mysql> FLUSH PRIVILEGES;Query OK, 0 rows affected (0.00 sec)

来源地址：https://blog.csdn.net/Julia_up/article/details/126776244