mysql权限
显示用户权限
mysql> show grants for jeffrey@localhost;
通常,数据库管理员首先创建用户,定义其非特权特征,例如其密码,是否使用安全连接以及对服务器资源的访问限制,然后使用grant来定义其权限。ALTER USER可用于更改现有账户的非特权特征。
CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;
撤销权限
REVOKE INSERT/ALL ON *.* FROM 'jeffrey'@'localhost';
显示用户权限
mysql> show grants for jeffrey@localhost;
通常,数据库管理员首先创建用户,定义其非特权特征,例如其密码,是否使用安全连接以及对服务器资源的访问限制,然后使用grant来定义其权限。ALTER USER可用于更改现有账户的非特权特征。
CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;
撤销权限
REVOKE INSERT/ALL ON *.* FROM 'jeffrey'@'localhost';