--创建用户
CREATE USER 'test'@'%' IDENTIFIED BY 'test';
--授权
GRANT ALL ON *.* TO 'test'@'%';
--修改密码
SET PASSWORD FOR 'test'@'%' = PASSWORD('test');
--创建用户
CREATE USER 'test'@'%' IDENTIFIED BY 'test';
--授权
GRANT ALL ON *.* TO 'test'@'%';
--修改密码
SET PASSWORD FOR 'test'@'%' = PASSWORD('test');
转载于:https://www.cnblogs.com/kuailewangzi1212/p/10676873.html