标签:
转载 |
标签:
sshdit |
分类: linux |
AcceptEnv
标签:
mysqlgrantrevoke |
分类: mysql |
1.今天需要修改线上数据库权限,查看某账号权限如下:
>show grants for community@localhost;
+-----------------------------------------------------------------------------------------+
| Grants for community@localhost |
+-----------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'community'@'localhost' IDENTIFIED BY
PASSWORD '565491d704013245' |
| GRANT ALL PRIVILEGES ON `community`.* TO 'community'@'localhost'
|
| GRANT ALL PRIVILEGES ON `mysql`.`componet` TO
'community'@'localhost' |
+-----------------------------------------------------------------------------------------+
然后纠结于GRANT USAGE ON是什么意思,在虚拟环境下创建了如上账号:
> grant usage on *.* to community@localhost identified by password '123456';
回收权限:revoke .. on .. from ..
> revoke