mysql 让所有IP访问数据库

收回所有的授权:

revoke all privileges on *.* from root@'%';

授权所有ip:

grant all privileges on *.* to 'root'@'%' identified by '密码';

原文地址:https://www.cnblogs.com/liugangBlog/p/9227759.html