mysql修改权限

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’;