新建用戶

create user 'test'@'%' identified by '123456';

授權

grant select,delete,update,create,drop on *.* to test@"%" identified by "123456";
grant all privileges on *.* to test@"%" identified by "123456";

刷新

flush privileges;

重啟

sudo service mysql restart

查看權限

show grants for 'test'@'%';