mysql8授权 grant all privileges on 语句报错

原授权语句

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

mysql8.0版本使用语句变为：

grant all privileges on *.* to 'root'@'localhost';