1、create user '用户名'@'%' identified by'密码';
2、create database 数据库名;
3、授予全部权限
grant all privileges on 数据库名.* to 用户名@localhost identified by '密码';
4、授予一部分权限
grant select,insert,delete,update,create,drop, alter, index, create view, show view on jpress.* to 用户名@"%" identified by "密码";
4、flush privileges;//刷新系统权限表