- Plesk for Linux
When trying to clone a WordPress instance with WordPress Toolkit, the following error is shown:
mysqldump: Got error: 1045: "Access denied for user 'admin_wordpress_user'@'127.0.0.1' (using password: YES)" when trying to connect.
Cannot login to MySQL under the user mentioned in the error message with password from
and 127.0.0.1 as host:
[root@plesk:~] # mysql -uadmin_wordpress_user -p -h 127.0.0.1
ERROR 1045 (28000): Access denied for user 'admin_wordpress_source'@'127.0.0.1' (using password: YES)
Access with same user and 'localhost' as host is successful:
[root@plesk:~] # mysql -uadmin_wordpress_source -p -h localhost
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 158630
Server version: 5.5.56-MariaDB-cll-lve MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
This is WordPress Toolkit bug with ID EXTWPTOOLK-806 that will be fixed in upcoming WordPress Toolkit updates.
As a workaround:
1. Go to Domains > example.com > Databases > User management and click the affected user (in this example, admin_wordpress_user). Proceed to 'Access control' and select 'Allow remote connections from', add: 127.0.0.1
2. Clone the instance again (it will fail with same error for target database)
3. Repeat the action from the step #1 to update setting for the target database user.