mysql无法删除用户,有下列报错信息,求解决方法!
mysql>selectuser,hostfrommysql.user->;+------+-----------+|user|host|+------+--------...
mysql> select user,host from mysql.user
-> ;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| | Client-03 | <-----#想要删除这个
| root |Client-03 |
| | localhost |
| root | localhost |
+------+-----------+
5 rows in set (0.00 sec)
mysql> drop user ""@Client-03;
ERROR 1064 (42000): You have an error in your SQL syntax; checkthe
manual that corresponds to your MySQL server version for theright
syntax to use near '-03' at line 1
mysql> 展开
-> ;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| | Client-03 | <-----#想要删除这个
| root |Client-03 |
| | localhost |
| root | localhost |
+------+-----------+
5 rows in set (0.00 sec)
mysql> drop user ""@Client-03;
ERROR 1064 (42000): You have an error in your SQL syntax; checkthe
manual that corresponds to your MySQL server version for theright
syntax to use near '-03' at line 1
mysql> 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询