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 ‘idnIn_k123′ WITH GRANT OPTION’ at line 1

在授权远程连接mysql8的时候,发生了错误: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 ‘idnIn_k123′ WITH GRANT OPTION’ at line 1

解决方式:update user set host=’%’ where user=’root’;


111 Clicks !

发表评论

电子邮件地址不会被公开。