mysql时出现:is not allowed to connect to this MySQL serverConnection closed by foreign host问题的解决
这个原因是因为索要链接的mysql数据库只允许其所在的服务器连接,需要在mysql服务器上设置一下允许的ip权限,如下:
1.连接mysql
mysql -u root -p
- 1
如图:
2.授权
grant all privileges on *.* to 'root'@'192.168.0.1' identified by '123456';
- 1
如图:
当然,如果想给所有ip都赋予权限,则这样:
grant all privileges on *.* to 'root'@'%' identified by '123456';
- 1
3.使授权立即生效
flush privileges;
- 1
如图:
耐得住寂寞,才能登得顶
Gitee码云:https://gitee.com/lyc96/projects