新建用户
create user ‘kejin’@‘localhost’ identified by ‘123456’;
删除用户
DROP USER ‘kejin’@‘localhost’;
为所有数据库/表赋予 CREATE 和 INSERT 权限:
GRANT CREATE, INSERT ON . TO ‘myuser’@‘localhost’;
验证给用户赋予的全权限:
SHOW GRANTS FOR ‘myuser’@‘localhost’;
将全部的权限赋予所有数据库/表:
GRANT ALL ON . TO ‘kejin’@‘localhost’;
你也可以将用户现有的权限删除。使用以下命令废除"myuser"帐号的现有权限:
mysql> REVOKE ON .
FROM ‘myuser’@‘localhost’;查询所有用户
SELECT * FROM mysql.user