Mysql新建用户和授权

新建用户

create user username@'host';

授权

grant all privileges on *.* to 'username'@'host' identified by 'password' with grant option;

FLUSH   PRIVILEGES;