• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

problem with mysql admin password

I

InternetPower

Guest
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.
 
To encrypt the password manually, use this command-line call:
# /usr/local/psa/bin/init_conf -u -passwd <password> -encrypted-password

To decrypt the password, run:
# /usr/local/psa/bin/init_conf -u -passwd <password> -plain-password
 
Back
Top