MySQL用户与权限

-- 创建用户
CREATE USER 'james'@'localhost'
IDENTIFIED BY 'tiger';

-- 登录数据库
mysql -h localhost -u james -p

-- 修改用户账号
RENAME USER james@'localhost'
TO jack@'localhost';

-- 修改用户口令
SET PASSWORD FOR 'jack'@'localhost'=
PASSWORD('lion');

-- 删除用户
DROP USER 'jack'@'localhost';

-- 授予用户权限
GRANT SELECT,INSERT ON *.*
TO 'testUser'@'localhost'
IDENTIFIED BY 'testPwd'
WITH GRANT OPTION;

-- 授权后查询用户权限
SELECT Host,User,Select_priv,Insert_priv,Grant_priv
FROM mysql.user
WHERE User='testUser';

-- 撤销用户权限
REVOKE INSERT ON *.*
FROM 'testUser'@'localhost';