OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
RE: Missing Entries

From: John Daisley (mg_sv_rhotmail.com)
Date: Wed Dec 09 2009 - 16:29:29 CST

I'm on my mobile so can't give you a link but you should read the reference manual section on
'post-installation setup and testing'.

Regards
John Daisley. -----Original Message----- From: Carlos Williams <carloswillgmail.com>
Sent: 09 December 2009 21:16
To: mysqllists.mysql.com
Subject: Missing Entries

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=john.daisleybutterflysystems.co.uk

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql