1. 创建用户
# username 是用户名,密码为123456
# localhost 用户只能在本地登录
CREATE USER username@localhost IDENTIFIED BY '123456';
# % 可以在任何一台电脑上都可以登录
CREATE USER username@'%' IDENTIFIED BY '123456';
2. 授权
# SELECT, INSERT, UPDATE 设置用户的操作权限
GRANT SELECT, INSERT, UPDATE ON mq.* TO username@localhost;
# 最大权限
GRANT ALL PRIVILEGES ON *.* TO username@localhost;
补充:
# 创建用户同时授权
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED by '1234';
flush privileges;
(授权只能root用户使用)
3. 查看授权
SHOW GRANTS FOR username@localhost;
4. 撤销授权
REVOKE SELECT ON mq.* FROM username@localhost;
(撤销授权只能root用户使用)
5. 删除用户
DROP USER username@localhost;