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
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

changed admin password in mysql DB now I cant login

Discussion in 'Plesk for Linux - 8.x and Older' started by crankin, Feb 5, 2006.

  1. crankin

    crankin Guest

    0
     
    Well after you stop LYAO maybe some one can help.

    For some reason, and dont ask me why I changed the admin password in the mysql.user table. Then when I tried to go to my Plesk login screen i got the following message

    ERROR: Unable to connect to database: saved admin password is incorrect. 0: /usr/local/psa/admin/auto_prepend/auth.php3:67 psaerror(string "Unable to connect to database: saved admin password is incorrect.")

    I took a look at auth.php and it's just byte code it seems. I'm guessing it is cached info on the old password. I was thinking about clearing it, and seeing if that would help but I think I'll just ask the folks here first. Thanks in Advance
     
  2. crankin

    crankin Guest

    0
     
    got the answer

    Log on to your dedicated server via SSH with your root username

    Stop the MySQL process with the following command:


    /etc/init.d/mysqld stop


    Restart it without the user information:


    /usr/bin/safe_mysqld --skip-grant-tables &


    Now you should be able to log in without the root password:


    mysql -u root


    While you are at the mysql> prompt enter:


    UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='admin'; (remember to include the ';' and that newpwd should be the admin password)

    and then

    FLUSH PRIVILEGES;


    I did everything else correctly I just never flushed the privileges that is why i wasn't able to login in even after i changed the password back. So I would just like to thank my self for helping myself out. I really appreciate it.
     
  3. mppl

    mppl Guest

    0
     
Loading...