• 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!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

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

maredzki

New Pleskian
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!
 
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.
 
Back
Top