mysql8修改密码

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
ERROR 1410 (42000): You are not allowed to create a user with GRANT

从MySQL 8开始，您不再可以（隐式）使用GRANT命令创建用户。请改用CREATE USER，然后使用GRANT语句：

> CREATE USER 'root'@'%' IDENTIFIED BY 'root';

> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

> flush privileges;