Magento 1.9.1 Porto theme
I have had a problem twice before where I could not log into the Magento Admin panel with my user name and password. I had to use code in the mySQL to change the password for my Admin user account.
This actually started a couple of hours ago. We have 3 Active accounts:
1 (mine) with the Admin privileges and 2 with a specific defined User roles.
The 2 accounts with specific defined User roles lost access first; then I went to the User's area in the Admin panel and found that those 2 accounts were set to DISABLED instead of Enabled. I created a new user account so that I could give it to the other 2 people but shortly after I did that - I was logged off from the Admin panel and was never able to log back in. The new user account I created does NOT work either.
I tried to run the following command in the SQL tab of the correct database via mySQL:
UPDATE mg_admin_user SET
password= md5('test'), is_active = 1 WHERE
but it just says that it took something like 0.003 seconds and there were no rows to update.
The interesting things is that when I open up the rows of the database and look at:
It actually has all the roles I defined before in it!
But when I open up the 'mg_admin_user' --) it is empty.
What do you think happened? Did somebody hack us and deleted all the user accounts?
How can I fix it? Is there a way to add a user account back into the database? Or is there something else I'm missing?