mysql 提示Host ‘DESKTOP-FJ1G3EV‘ is not allowed to connect to this MysQL server 5.7

点击mysql client

show databases 显示所有数据库

切换到mysql; use mysql

修改配置
update user set host = ‘%’ where user =‘root’；

host修改完成后执行以下命令使配置立即生效。

flush privileges;

然后在查看配置

select host from user where user=‘root’;

看到多了一行%就行了