Mysql8.0赋予用户对数据库的全部权限相较于Mysql5.7的改动

#建新用户user，新用户密码为PASSword123.
mysql>create user "user"@"localhost"identified by 'PASSword123.';
#赋予用户对数据库wordpress的全部权限
mysql>grant all privileges on wordpress.* to 'user'@'localhost' identified by 'PASSword123.';
#使配置生效。
mysql>flush privileges;
#退出MySQL。
mysql>exit;

mysql> grant all privileges on wordpress.* to 'user'@"localhost" identified by 'PASSword123.';
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 'PASSword123.'' at line 1

#创建用户
 mysql> create user 'user'@"localhost" IDENTIFIED BY 'PASSword123.';

#授权
mysql> grant all on wordpress.* to "user"@"localhost" with grant option;
#使配置生效。
mysql>flush privileges;
#退出MySQL。
mysql>exit;