【MySQL】创建用户，给用户分配权限

MySQL创建用户：

CREATE USER username@localhost IDENTIFIED BY 'password';

给用户分配权限：

grant select,insert,update,delete on db_push.* to username@"%" Identified by "password";
flush privileges;

查看用户信息：

select host,user from mysql.user;

修改密码：

 grant   all   privileges   on   pureftpd.*   to   koko@localhost   identified   by   'mimi';