MySql版本:MySql8+
# 创建一个新的mysql用户"test"
mysql> create user 'test'@'%' identified by 'abc_123';
# 给新用户复制权限
mysql> grant all privileges on *.* to 'test'@'%' with grant option;
# 修改新用户密码策略,修改为mysql_native_password,这里的"%"(允许所有主机访问)
ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'abc_123';
# MySQL8版本中新增了一个system_user帐户类型,当给用户赋予权限时会报
# "ERROR 1227 (42000): Access denied; you need (at least one of) the SYSTEM_USER privilege(s)
# for this operation" 的错误,原因是由于root用户没有SYSTEM_USER权限，把权限加入后即可解决
mysql> grant system_user on *.* to 'root';
# 再次重复之前操作即可
mysql> ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'abc_123';
