mysql创建用户并手授权

--创建用户
CREATE USER 'test'@'%' IDENTIFIED BY 'test';

--授权
GRANT ALL ON *.* TO 'test'@'%';

--修改密码
SET PASSWORD FOR 'test'@'%' = PASSWORD('test');