#创建新用户:
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
#赋予权限:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
注:此修改仅支持mysql5.6及以下的版本,5.7版本后的密码字段不再是password
#创建新用户:
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
#赋予权限:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
注:此修改仅支持mysql5.6及以下的版本,5.7版本后的密码字段不再是password