Resolved Unable to export database. Error message: -- Connecting to localhost... mariadb-dump: Got error: 1045: "Access denied for user '<userx>'@'localhost'

[maredzki]

Server operating system version

ubuntu 24.04.02

Plesk version and microupdate number

Plesk Obsidian 18.0.68 Update 2

I've migrated from Plesk on one server to Plesk to another (ubuntu 18 to ubuntu 24). I know there is a database upgrade that happened between those releases. All works, wordpress sites are accessible until I try to do any maintenance (upgrade wordpress or even create a backup).

If I try to do either one of those two, it throws this error:
Unable to export database. Error message: -- Connecting to localhost... mariadb-dump: Got error: 1045: "Access denied for user '<userx>'@'localhost' (using password: YES)" when trying to connect ...

Any ideas on how to fix this?

Thank you!

 

[maredzki]

I was able to solve it.

Checked what was the password in the wp-config.php;
/** MySQL database password */
define( 'DB_PASSWORD', '<removed>' );

Copied that value and reset the password in WordPress extension -> WordPress instance -> Database tab -> Database user name and click on [change].
Paste the copied password value to Database user password textbox and save.