收回所有的授权:
revoke all privileges on *.* from root@'%';
授权所有ip:
grant all privileges on *.* to 'root'@'%' identified by '密码';
收回所有的授权:
revoke all privileges on *.* from root@'%';
授权所有ip:
grant all privileges on *.* to 'root'@'%' identified by '密码';
转载于:https://www.cnblogs.com/liugangBlog/p/9227759.html