创建库并指定字符集
CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
查看用户
SELECT User, Host, Password FROM mysql.user;
创建用户
CREATE USER '用户名'@'%' IDENTIFIED BY '密码';
用户授权
grant select,insert,update,delete on *.* to '用户名'@'%'
查看用户授权
show grants for '用户名'@'%'