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) 编辑 收藏 举报