创建用户并授权
|
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