mysql使用授权远程登录相关文章

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" and host = "%";
flush privileges;

----------------------------------------------------------

blog.youkuaiyun.com/qq_26710805/article/details/79776897