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';