从 MySQL 8 开始,不可以(隐式)使用GRANT命令创建用户。改用CREATE USER,然后再使用GRANT声明:

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