Mysql loses its root password
- by RubyDev
I am having a strange problem, my mysql loses/resets the root password automatically. By which I mean that it resets it to none. It has happened twice this month. I am worried that it can be a security issue as data is open waiting only for someone trying no password!
Here is the version:
mysql --version
mysql Ver 14.14 Distrib 5.1.56, for redhat-linux-gnu (i386) using readline 5.1
Any help would be appreciated.
Update:
Output of select user, host, password from mysql.user; how it looks after the password got reset
| root | localhost |
| root | 127.0.0.1 |
| | localhost | |
| admin | localhost | ################################# | (I have removed the actual output with #)
So all the passwords are blank, except for for another user named 'admin'
