mysql8常见错误及解决办法(1046 、1410、1064)
【错误代码: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'@'%' ;
【错误代码:1410 】
https://blog.csdn.net/qq_34680444/article/details/86238516
【错误代码:1046 】