mysql 1130 - Host ‘192.168.56.1‘is not allowed to connect to this MySQL server

问题描述：本地数据库连接Linux数据库错误

1130 -Host '192.168.56.1’is not allowed to connect to this MySQL server

解决方法：

1. Linux进入mysql数据库

 sudo docker exec -it mysql mysql -uroot -p123456

2. 查看数据库

show databades;

3. 切换数据库

use mysql;

4. 查看表

show tables;

5. 查看本地用户

select Host,User,authentication_string from user;

6. root用户的Host修改为%

update user set host = '%' where user ='root';

7. 刷新权限

flush privileges;

8. 查看
   

9. 重新连接即可