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