Issue Upgrade from Onyx 17.8.11 to Obsidian 18.0.25 via Autoinstaller: Access denied for user 'admin'@'localhost'

[ThorstenMelzer]

It isn't possible to upgrade due to this error message:
Check the error reason (see log file: /var/log/plesk/install/plesk_18.0.25_installation.log), fix and try again
mysqldump: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: YES) when trying to connect

- phpMyAdmin is reachable from plesk database server
- all databases are available and accessible (also 'psa')
- /etc/psa/.psa.shadow exists and stored the secure password
- via SSH I am able to connect to mysql: mysql -uadmin -p'$AES-128-XXX(...)XXXw=='

How can I fix this error and update to Obsidian 18.0.25?

It is a hosted vServer from IONOS with Ubuntu 16.04.

Best
Thorsten

 

[IgorG]

Can you create psa database dump with command:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa > /tmp/psa.`date +%F_%H.%M`.sql

?

 

[ThorstenMelzer]

Hi IgorG,
with this command I cannot create a dump:
mysqldump: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: YES) when trying to connect
The file was created as psa.2020-03-30_12.54.sql with 0 KB

If I use instead of MYSQL_PWD='cat /etc/psa/.psa.shadow' the paramter p'$AES-128-XXX(...)XXXw==' I could create a dump:

 

[IgorG]

Try to use solution from this KB article https://support.plesk.com/hc/en-us/...-for-user-admin-localhost-using-password-YES-