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=arch...@jab.org
