Mysql8 【错误代码:1064 】 ERROR 1064 (42000): You have an error in your SQL syntax;

1,251 阅读1分钟

今天安装mysql8遇到了

【错误代码:1064  】

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 'root' with grant option' at line 1

mysql8中已经不支持grant all privileges on . to 'root'@'%' identified by '密码' with grant option这种写法。

grant all privileges on . to 'root'@'%'` `;

感谢www.cnblogs.com/qiupiaohuji…这位网友的分享