创建用户

1
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password123';

删除用户

1
DROP USER 'username'@'localhost';

授予用户权限

1
2
GRANT SELECT, UPDATE ON foo.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

查看某个用户的权限

1
SHOW GRANTS FOR 'username'@'localhost';

删除用户权限

1
2
REVOKE ALL PRIVILEGES ON foo.* FROM 'username'@'localhost';
FLUSH PRIVILEGES;