If you only want root to be able to log in locally then you only need 'root'@'localhost' unless you are using tcp connections.
regards John On Tue, Mar 30, 2010 at 11:25 PM, Carlos Mennens <carlosw...@gmail.com>wrote: > Today I installed MySQL 5.1.45-1 on my production server and it > recommended that I run the following: > > /usr/bin/mysql_secure_installation > > When I ran this, it simply guided me to do the following: > > - set root password > - disable remote login for root > - remove 'anonymous' user accounts > - delete 'test' database > - reload privileges now > > After doing all the above, I checked my user table and noticed that it > also removed 'r...@127.0.0.1' & 'r...@hostname' accounts. I recall > hearing from many admins that MySQL expects and needs there to be > three accounts for root. Them being 'localhost', 127.0.0.1, and > hostname. Is this false information? > > mysql> select User, Password, Host from user; > +------+-------------------------------------------+-----------+ > | User | Password | Host | > +------+-------------------------------------------+-----------+ > | root | *951527F19014ABEFD0390B1409B4CCA97F86AE1F | localhost | > +------+-------------------------------------------+-----------+ > 1 row in set (0.00 sec) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > >