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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
