#创建数据库
create database fydata default character set utf8 collate utf8_general_ci;
#创建用户
create user 'fuying'@'%' identified by 'fuying';
#授权 增删改查
grant select,insert,update,delete,create on fydata.* to 'fuying';
flush privileges;
#查看用户权限
show grants for 'fuying';
#移除权限
revoke drop on fydata.* from 'fuying';
