I was checking my fresh install of MySQL and noticed I had empt spaces
or missing entries in some sections when I did a search for users on
the 'mysql' database. I checked the MySQL FAQ's and Google and nothing
gave me what I am looking for. I can't understand what this entries
are blank for:
mysql> select User, Password, Host, Insert_priv from user;
+--------+-------------------------------------------+-----------+-------------+
| User | Password | Host | Insert_priv |
+--------+-------------------------------------------+-----------+-------------+
| root | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | localhost | Y |
| root | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | mail | Y |
| root | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | 127.0.0.1 | Y |
| | | localhost | N |
| | | mail | N |
| carlos | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | localhost | N |
+--------+-------------------------------------------+-----------+-------------+
I see there are 3 root users:
- localhost
- mail (hostname)
- 127.0.0.1 (localhost IP)
But after that there are two entries that are blank for 'localhost' &
'mail'. Does anyone know what they are and if I can remove them. They
appear useless and clutter my database. Sorry, I am OCD.
