grant all privileges on *.* to '用户名'@'%' identified by '登录密码' with grant option;
flush privileges;
实践:
mysql -uroot -proot
增加授权
grant all privileges on *.* to 'laowang'@'%' identified by 'qq123456' with grant option;
flush privileges;
取消授权
非必须操作:
REVOKE ALL PRIVILEGES ON *.* FROM 'laowang'@'%';
必须操作:
use mysql
DELETE FROM user WHERE user="laowang";
flush privileges;
----------------------------------------------------------
blog.csdn.net/qq_26710805/article/details/79776897