- Plesk for Linux
Note: This article has the reference to the issue with the fix available:
- #EXTWPTOOLK-806 "Setting skip_name_resolve = on in the MySQL server configuration resulted in failure to clone instances."
- WordPress Toolkit 2.4.0 16 November 2017
When trying to clone a WordPress instance with WordPress Toolkit, the following error is shown:
CONFIG_TEXT: 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:
# 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:
# 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.
MariaDB [(none)] >
This is WordPress Toolkit bug with ID EXTWPTOOLK-806 that was fixed in WordPress Toolkit 2.4.0 .
Login to Plesk and 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
Clone the instance again (it will fail with same error for target database)
Repeat the action from the step #1 to update setting for the target database user.