mysql新建用户并授权

增加用户

INSERT INTO mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) VALUES("%","user",PASSWORD("user"),"","","");

为用户授权

grant all privileges on user.* to user@'%' identified by 'user' with grant option;

更新权限

flush privileges;

设置密码

set password for user@'%'=password('user');