### mysql 8.0创建用户授权远程登录
# 1、新建用户(mysql 8.0不能给自己授权)
CREATE user 'test'@'%' IDENTIFIED BY 'test';
# 2、授权用户权限
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%';
# 3、修改密码
ALTER user 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'test';
# 4、刷新保存
FLUSH PRIVILEGES;