MySQL server version for the right syntax to use near ‘IDENTIFIED BY ‘**’ WITH GRANT OPTION’

发表评论阅读(2844)

很久没在服务器上装环境，今天安装 MySQL 授权时报如题错误，我输入的命令是授权用户支持远程访问

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

原来从 MySQL 8 开始，不能支持一段式授权用户，需要先创建再授权。

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

本文由老郭种树原创，转载请注明：https://guozh.net/mysql-server-version-for-the-right-syntax-to-use-near-identified-by-with-grant-option/

发表回复取消回复