# 创建用户 venus， 密码123，限制本地登陆

CREATE USER 'venus'@'localhost' IDENTIFIED BY '123';

# 授权 SELECT,INSERT,UPDATE 3个权限 给venus用户并绑定simon库

GRANT SELECT,INSERT,UPDATE ON `simon`.* TO 'venus'@'localhost';

# 刷新权限

FLUSH PRIVILEGES;