数据库安装完成后，默认是不能远程登陆的，只能在本地用localhost 或者127.0.0.1登录访问，如果需要远程登录，则需要修改mysql设置，具体修改方式：
1、本地登录mysql：
[root@localhost ~]$ mysql -u root -p1234562、查看数据库中mysql表中的权限设置：
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select host, user from user;
+-----------+---------------+
| host | user |
+-----------+---------------+
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+---------------+
3 rows in set (0.00 sec)
3、修改root用户权限：
mysql> update user set host = ‘%’ where user = ‘root’;4、此时，root用户的权限已经允许非localhost登录文章来源：https://www.toymoban.com/news/detail-570864.html
mysql> select host, user from user;
+-----------+---------------+
| host | user |
+-----------+---------------+
| % | root |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+---------------+
3 rows in set (0.00 sec)5、最后，刷新设置，即可远程登录文章来源地址https://www.toymoban.com/news/detail-570864.html
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)到了这里，关于message from server: “Host is not allowed to connect to this MySQL server“问题的解决办法的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
