Our MySQL log displayed a warning on restart about 2 root users not having passwords.
I went into MySQL and checked all users:
mysql> select * from mysql.user;
and see:
Host | User | Password
localhost root *76685yt868itetc
web12-b0 root
127.0.0.1 root
First off, why are there 3 root users (and do we need 127.0.0.1 since we have localhost)?
Second, why would two of them not have passwords set?
Third, do the web12-b0 and 127.0.0.1 hosts have full root access without having to use a password (as it appears)?
Fourth, is there some valid reason for this or should I suggest the admin put passwords on those two hosts?
Thanks for your answers.