1.创建数据库(指定编码格式为utf-8)
create database metadata character set utf8;
2.创建用户和密码
create user metadata identified by '123456';
3.授权
授权格式:grant 权限 on 数据库.* to 用户名@登录主机 identified by "密码";
grant all on metadata.* to metadata@'%' identified by 'metadata';
grant all on metadata.* to metadata@'localhost' identified by 'metadata';
4.刷新权限相关表
flush privileges;