当前位置：网站首页>mysql_账号授权权限回收、账号锁定解锁、账号创建删除

mysql_账号授权权限回收、账号锁定解锁、账号创建删除

2022-07-20 05:31:00 【angela_dba_chao】

1 创建账号

CREATE USER 'useraccount'@'%' IDENTIFIED BY 'password';

2 账号赋权

GRANT ALL ON *.* TO 'useraccount'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES; 

3 查看账号权限

show grants for [email protected]`%`;

4 账号权限收回

revoke all privileges on *.* from `useraccount`@`%`;

5 锁定账号

ALTER USER 'useraccount'@'%' ACCOUNT LOCK;

6 查看帐户是否已解锁

SHOW CREATE useraccount

select host,user,account_locked from mysql.user where user in ('useraccont');

7 解锁账号

ALTER USER [IF EXISTS] useraccount ACCOUNT UNLOCK;

8 删除账号

drop user useraccount;

delete from user where user='useraccount' and host='%';

原网站

版权声明
本文为[angela_dba_chao]所创，转载请带上原文链接，感谢
https://blog.csdn.net/wanglifengchao222/article/details/125734015

边栏推荐

猜你喜欢

随机推荐