mysql - schema/架构/

 

--创建schema

create schema zzz default character set utf8 collate utf8_general_ci;

 

--用户授权数据库

grant select,insert,update,delete,create on zzz.* to user;

--立即启用配置

flush  privileges;

 

--删除数据库

drop schema zzz;