创建用户并授权
1 |
grant 权限列表 on 数据库 to '用户名'@'访问主机' identified by '密码'; |
示例:
1 |
grant select on jing_dong.* to 'laowang'@'localhost' identified by '123456'; |
1 |
grant all privileges on jing_dong.* to "laoli"@"%" identified by "12345678" |
查看用户有哪些权限
1 |
show grants for laowang@localhost; |
修改用户权限
1 |
grant 权限名称 on 数据库 to 账户@主机 with grant option; |
修改密码
1 2 3 |
update user set authentication_string=password('新密码') where user='用户名'; 例: update user set authentication_string=password('123') where user='laowang'; |
1 |
结束以后要刷新权限:flush privileges |
删除用户
方法1:
1 2 3 |
drop user '用户名'@'主机'; 例: drop user 'laowang'@'%'; |
方法2:
1 2 3 4 5 6 |
delete from user where user='用户名'; 例: delete from user where user='laowang'; -- 操作结束之后需要刷新权限 flush privileges |
忘记密码的方式:
https://blog.csdn.net/lxpbs8851/article/details/10895085
未经允许不得转载:MR LYU » mysql 用户管理