MYSQL8.0版本输入grant delete on sm.student to 'wzq1'@'localhost' IDENTIFIED BY '123';报错信息为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 '123'' at line 1

在 MySQL 8.0 版本中，授权语句的语法发生了一些变化。正确的授权语句应该是:

GRANT DELETE ON sm.student TO 'wzq1'@'localhost' IDENTIFIED BY '123';

在这个语句中，`GRANT` 关键字后面跟上要授权的权限类型 `DELETE`，然后是要授权的表 `sm.student`，接着是要授权的用户 `'wzq1'@'localhost'`，最后是该用户的密码 `IDENTIFIED BY '123'`。需要注意的是，在 MySQL 8.0 版本中，`IDENTIFIED BY` 关键字必须放在授权语句的最后。

相关问题

mysql> GRANT ALL PRIVILEGES ON *.* TO zhangsan@'%' IDENTIFIED BY '123'; 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 '123'' at line 1

这个错误的原因是语法错误，正确的语法应该是在GRANT ALL PRIVILEGES ON *.* TO zhangsan@'%'后面加上WITH GRANT OPTION，并且在IDENTIFIED BY '123'前面加上一个关键字PASSWORD。正确的语法应该是：

GRANT ALL PRIVILEGES ON *.* TO zhangsan@'%' WITH GRANT OPTION IDENTIFIED BY '123';

这样就可以成功授权了。

nginx MySQL80 报错 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 '. TO 'root'@'%' IDENTIFIED BY '123456'' at line 1

对不起，刚才的回答中有一个错误。在 MySQL 中，授权语句的正确语法是：

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

在上述语句中，没有多余的点号“.”，正确的语法是将 "ON *.*" 放在 "GRANT ALL PRIVILEGES" 之后。再次对之前的错误表示歉意，并感谢您的指正。如果您还有其他问题，请随时提问。