mysql创建数据库，用户，授权基操

# 创建数据库
create database test;
# 创建用户并设置密码
create user 'test'@'%' identified by '123456';
# 设置密码
SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');
# 分配权限
GRANT ALL PRIVILEGES ON test.* to 'test'@'%';
# 刷新权限
flush privileges;