mysql> grant all privileges on *.* to root @’%’ identified by '12345678' with grant option;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 '
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/30 04:25:16
![mysql> grant all privileges on *.* to root @’%’ identified by '12345678' with grant option;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 '](/uploads/image/z/7345746-18-6.jpg?t=mysql%3E+grant+all+privileges+on+%2A.%2A+to+root+%40%E2%80%99%25%E2%80%99+identified+by+%2712345678%27+with+grant+option%3BERROR+1064+%2842000%29%3AYou+have+an+error+in+your+SQL+syntax%3B+check+the+manual+that+corresponds+to+your+MySQL+server+version+for+the+right+syntax+to+use+near+%27)
mysql> grant all privileges on *.* to root @’%’ identified by '12345678' with grant option;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 '
mysql> grant all privileges on *.* to root @’%’ identified by '12345678' with grant option;
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 '12345678' with grant option' at line 1
mysql> grant all privileges on *.* to root @’%’ identified by '12345678' with grant option;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 '
grant all privileges on *.* to root@'%' identified by '12345678' with grant option;
你的分号是中文的,改过来就行了,给个好评的呀.