1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice

Plesk 7.5.1 Admin Mysql User Deleted!!

Discussion in 'Plesk for Linux - 8.x and Older' started by Traged1, Mar 17, 2005.

  1. Traged1

    Traged1 Guest

    0
     
    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..
     
  2. Traged1

    Traged1 Guest

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

    Traged1 Guest

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