mysql 匿名ユーザの削除
次の通りuserが匿名であるものを削除する
mysql> select user,host,password from mysql.user;
+------+-----------+------------------+
| user | host | password |
+------+-----------+------------------+
| root | localhost | |
| root | exhost | |
| root | 127.0.0.1 | |
| | localhost | |
| | exhost | |
+------+-----------+------------------+
削除方法
DELETE FROM mysql.user WHERE User = '';