如何在MySQL 8.0中授予root用户所有特权 [英] How to grant all privileges to root user in MySQL 8.0

问题描述

尝试

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

获取

错误1064(42000):您的SQL语法有错误；检查手册 对应于您的MySQL服务器版本，以在第1行的'IDENTIFIED BY'root'WITH GRANT OPTION''附近使用正确的语法.

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'root' WITH GRANT OPTION' at line 1.

注意:在以前的版本中尝试使用时，效果相同.

Note: The same is working when tried in previous versions.

也尝试过

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

获取

错误1410(42000):不允许使用GRANT创建用户

ERROR 1410 (42000): You are not allowed to create a user with GRANT

MySQL(8.0.11.0)用户名/密码为root/root.

MySQL (8.0.11.0) username/password is root/root.

推荐答案

从MySQL 8开始，您不再可以(隐式)使用GRANT命令创建用户.使用创建用户，然后使用 GRANT 声明:

Starting with MySQL 8 you no longer can (implicitly) create a user using the GRANT command. Use CREATE USER instead, followed by the GRANT statement:

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

关于的安全风险的警告，请参阅:

Caution about the security risks about WITH GRANT OPTION, see:

• 授予数据库的所有权限

这篇关于如何在MySQL 8.0中授予root用户所有特权的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！