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

problem with mysql admin password

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by InternetPower, Sep 29, 2011.

  1. InternetPower

    InternetPower Guest

    0
     
    Plesk 10.3.1 - Centos 6.0 - x86_64

    On one server I cannot logon to mysql from shell using the admin password, the same that works to logon from the web interface.
    Instead to logon to mysql I have to use the password stored in /etc/psa/.psa.shadow AS IS, while the admin password (the same I can get using "/usr/local/psa/bin/admin --show-password") is it's decrypted form.

    So the problem is that when I change the admin password, Plesk sets it enncrypted in /etc/psa/.psa.shadow but then behaves like in the previous versions of Plesk where in /etc/psa/.psa.shadow it's the real password, and uses it to set the password in the grant tables of mysql.
    From the web interface I have no problem logging on using the password I choosed.

    Maybe there is a switch to tell Plesk to consider the password stored in /etc/psa/.psa.shadow the real password OR the encrypted form (for example for compatibility reasons during Plesk upgrades), but where?

    How can I fix it?
    Thanks.
     
  2. mrwolf

    mrwolf Guest

    0
     
    same issue here. any hint?
     
  3. itmnetcom

    itmnetcom Basic Pleskian

    14
    80%
    Joined:
    Aug 1, 2011
    Messages:
    37
    Likes Received:
    0
    Same issue here.

    thanks....
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,554
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    To encrypt the password manually, use this command-line call:
    To decrypt the password, run:
     
Loading...