MySQL8 创建用户并能远程登录

MySQL8 开始不能使用GRANT命令创建用户，要使用CREATE USER替换

CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;