MySQL新建用户和修改用户密码

GRANT ALL ON *.* TO 用户名@"%" IDENTIFIED BY "密码" WITH GRANT OPTION;

UPDATE mysql.user SET Password = OLD_PASSWORD('密码') WHERE Host = '%' AND User = '用户名';

FLUSH PRIVILEGES;