CAYZLH：数据库

MySQL创建用户

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

MySQL创建数据库

create schema [databasename] default character set utf8 collate utf8_general_ci;

MySQL用户授权数据库

第一种：

grant select,insert,update,delete,create on [databasename].* to [username];

第二种：

grant all privileges on [databasename].* to [username]@'%' identified by 'yourpassword';
flush privileges;

ERROR 1820 (HY000)

创建用户的时候报错以及解决方法

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

修改策略，及密码长度

set global validate_password_policy=0;
set global validate_password_length=1;

未完待续..