老骥伏枥,日行千里
MySQL8 开始不能使用GRANT命令创建用户,要使用CREATE USER替换
GRANT
CREATE USER
CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES;