mysql user削除 error

Question

mysqlにてユーザーを削除したいのですが、削除することが出来ません。

MariaDB [(none)]> SELECT FROM mysql.user;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM mysql.user' at line 1
MariaDB [(none)]> SELECT user, host  FROM mysql.user;
+---------------+------------+
| user          | host       |
+---------------+------------+
| member_user   |  localhost |
| root          | 127.0.0.1  |
| root          | ::1        |
|               | localhost  |
| board_user    | localhost  |
| pma           | localhost  |
| root          | localhost  |
| shopping_user | localhost  |
+---------------+------------+
8 rows in set (0.001 sec)

MariaDB [(none)]> DROP USER member_user@ localhost;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'localhost' at line 1
MariaDB [(none)]> DROP USER member_user@localhost;
ERROR 1396 (HY000): Operation DROP USER failed for 'member_user'@'localhost'

よろしくお願いします。

Answer 1

+---------------+------------+
| user          | host       |
+---------------+------------+
| member_user   |  localhost |
| root          | 127.0.0.1  |
| root          | ::1        |
|               | localhost  |
| board_user    | localhost  |
| pma           | localhost  |
| root          | localhost  |
| shopping_user | localhost  |
+---------------+------------+

member_user の host だけ localhost の前に半角スペースが入っているのが気になります。
あまり見ないですが、

DROP USER member_user@ localhost;
DROP USER 'member_user'@' localhost';

こういう感じになるのかなぁと思っています。

ご参考になれば嬉しいです！

Comments

[mitsunuma]

ありがとうございます。

[mitsunuma]

解決しました。