创建数据库
CREATE DATABASE IF NOT EXISTS `数据库` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
创建用户和密码
CREATE USER '用户名'@'%' IDENTIFIED BY '密码';
赋予用户拥有数据库的权限
GRANT SELECT,INSERT,UPDATE,REFERENCES,DELETE,CREATE,DROP,ALTER,INDEX,TRIGGER,CREATE VIEW,SHOW VIEW,EXECUTE,ALTER ROUTINE,CREATE ROUTINE,CREATE TEMPORARY TABLES,LOCK TABLES,EVENT ON `数据库`.* TO '用户名'@'%';