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;

posted on 2019-08-23 17:12  coding-farmer  阅读(380)  评论(0编辑  收藏  举报

导航