I'm a new MySQL DBA taking over admin duties for an existing MySQL nonclustered 4.1 installation. It has 6 small user databases. So in the mysql database, I run the query
Select host, user, password from user; Which returns the following: +---------------------+-----------------+------------------------------- ------------+ | host | user | password | +---------------------+-----------------+------------------------------- ------------+ | localhost | root | (long hex string) | | localhost network name | root | | | localhost network name | | | | localhost | | (long hex string) | | localhost | one_user | (long hex string) | | % | one_user | (long hex string) | | % | root | (long hex string) | | localhost | two_user | (long hex string) | | IP address x | one_user | (long hex string) | | IP address y | one_user | | +---------------------+-----------------+------------------------------- ------------+ Does this mean that: 1. Line 2 above: root can log in with a blank password from (localhost network name)? 2. Line 3 above: A blank user/password can be used to log in from (localhost network name)? 3. Line 4 above: A blank user can be used to log in from localhost, but a password has been specified? 4. Line 10 above: User "one-user" can be used to log in from IP address y with a blank password? Or am I reading this incorrectly?
