需求:
1. 创建一个用户
2. 该用户只拥有某个数据库的权限
语句:
1. 创建用户
CREATE USER 用户名@localhost IDENTIFIED BY '密码';
2. 授权
GRANT ALL PRIVILEGES on 数据库名.* to 用户名@'localhost' identified by '密码';
3. flush
flush privileges;
修改密码
grant all privileges on pureftpd.* to koko@localhost identified by 'mimi';