Author: 林子雨老师

[MySQL 8] 授权 GRANT ALL 出现错误 ERROR 1064 (42000) You have an error in your SQL syntax

问题介绍

MySQL8.0以前的版本通过以下代码可以实现授权:

mysql>grant all privileges on test.* to test@'%' identified by '123456';

但是MySQL8.0以后的版本,会出现:
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…的错误

继续阅读