创建数据库
CREATE DATABASE 数据库名称 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
创建用户
CREATE USER 'user'@localhost IDENTIFIED BY 'password'; ## 本地访问
CREATE USER 'user'@'%' IDENTIFIED BY 'password'; ## 任意ip访问
给权限
GRANT ALL PRIVILEGES ON 数据库名.* TO '用户名'@localhost; ## 给单独数据库的权限
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password'; ## 给全部权限