mysql学习记录之创建数据库指定编码

gbk:
create database demo default character set gbk collate gbk_chinese_ci;

utf8:
create database demo default character set utf8 collate utf8_general_ci;

创建用户，权限同root

create user 'admin'@'%' identified by 'XX';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY 'XX' WITH GRANT OPTION;
ALTER USER 'admin'@'%' PASSWORD EXPIRE NEVER;
flush privileges;

create user 'root'@'ip' IDENTIFIED BY '1qaz@WSX';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip';
FLUSH PRIVILEGES;