MySQL Usernames lost

[torqhost]

Hello,

I had an issue today where all mysql usernames were basically lost in mysql.
Basically I noticed that I was getting access denied errors for mysql on all sites hosted on the server, yet the server was running. I logged in to DA and it said the server is running and was showing all the users for the databases. When I tried to edit the password for any user I got a user doesn't exist message. Same happened when I tried deleting the user.
What I ended up doing is logging into mysql as -u root (that was not lost for some reason) and granting it manually.

I would like to know what happened. Could the server been compromised? Is this a mysql bug or a DA bug. I can provide any additional info as needed. MySQL logs were empty though for some reason.

Dennis

 

[scsi]

Login to mysql as root and try:

SELECT user,password,host from mysql.user;

it should show the users.

 

[torqhost]

Yes, it does show the users. MySQL didn't interpret them as such though. This is very weird because basically the machine was running for 200 days and on day 201 this happened. No reboot or anything, it just broke.