# 创建数据库
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;
每天都再努力一点。