Plesk 7.5.1 Admin Mysql User Deleted!!

[Traged1]

For some odd reason the admin user in the mysql database was deleted. Although the box has shown no signs of any rooting. All md5's check out fine and rkhunter and chrootkit all report everything is good.

Very strange.

To solve it:


add to:
-----------------------------------
vi /etc/my.cnf

skip-grant-privs
-----------------------------------

Then /etc/init.d/mysqld restart

Then,

----------------------------------
mysql -uadmin -p`cat /etc/psa/.psa.shadow`;
use mysql;

INSERT into user values ('localhost','admin',"Password(YOUR_PLESK_PASSWORD)" ,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','
Y','Y');
----------------------------------

Comment out:

-----------------------------------
vi /etc/my.cnf

# skip-grant-privs
-----------------------------------

Then,

/etc/init.d/mysqld restart

That should fix it, but if anyone has any idea's as to what could have cuased this please elaborate..

 

[Traged1]

By the way there was nothing out of the ordinary in the /root/.mysqld_history file either.

 

[Traged1]

I was getting all kinds of errors such as Access denied for admin@localhost, stored PLESK admin password does not match ect..