Resolved how to get the plesk obsidian mysql / mariadb (?) root-replacement user "admin" password?

[jmar83]

how to get the plesk obsidian mysql / mariadb (?) root-replacement user "admin" password?

"plesk sbin psadb --get-admin-password" does not work (How to retrieve administrator's Plesk database password on Plesk 17.8 for Windows? ) Message: `Unknown Plesk command-line utility: "psadb"`...


"cat /etc/psa/.psa.shadow" / "mysql -uadmin -p'...'" makes not sense (How to connect to MySQL on a Plesk for Linux server using a MySQL admin password in plain text ), because i don't want ro change its password. (maybe it's a risk, after that plesk maybe does not work anymore..?)


Thank you for your feedbacks.


Best regards, Jan

 

[sebgonzes]

plesk db ?

 

[jmar83]

i don't want the mysqlconsole, i need the CURRENT mysql admin user password..

 

[jmar83]

so i meant the obsidian equivalent for that one: How to retrieve administrator's Plesk database password on Plesk 17.8 for Windows?

how to get the current mysql admin user password in obsidian?

 

[Bitpalast]

# cat /etc/psa/.psa.shadow

Looks like an encrypted string, but works as a password when used directly as delivered from the output.

 

[sebgonzes]

# cat /etc/psa/.psa.shadow

Looks like an encrypted string, but works as a password when used directly as delivered from the output.

Exactly, mysql -uadmin -p`cat /etc/psa/.psa.shadow` has ALWAYS working in any plesk server

 

[jmar83]

Oh yes, that seems to be a password!! ;-)

Firstly, i was thinking it's a hash of it.

Now it works - thank you very much!!

Regards, Jan

 

[jmar83]

-> Issue - Can't access from external IP via "admin" and password from /etc/psa/.psa.shadow with allowed external access [checkbox] - why?

Hmm...?

 

[T2121]

Using this command would be a better way to login

mysql -uadmin -p$(cat /etc/psa/.psa.shadow)

 

[jmar83]

ok thx