ManageWP's Local Sync throwing DB error on latest "Local" version

ManageWP has a beta feature that allows you to sync between live site and local staging site but I’m having trouble getting it to play ball with Local. Here’s an overview of my setup and tests so far:

  • Windows 10 with both Local (newer) & Local by Flywheel installs
  • Live site hosted on Siteground running PHP 7.3.14 & MySQL 5.6.36
  • Local by Flywheel site running PHP 7.2.9 & MySQL 5.7.23
  • Local site running PHP 7.3.5 & MySQL 8.0.16
  • Trying to sync from Live site -> Local

When trying on the newer local install I get stuck on the following error:

We got an error while calling http://apppresserdev.local/?list_tables: [db_connect_error]: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. : 2002 If retrying doesn’t help, please contact our support.

When trying on the older local by flywheel install it throws some other minor errors but the process actually appears to run ok and completes the sync.

So there’s something different about the newer Local installation causing this error. The first thing that stands out is the bump in MySQL version but I’m not really sure beyond that how to troubleshoot or resolve this. Any ideas?

EDIT: Also tried a MariaDB 10.4.10 install on new local and got the same error as above.


Managed to solve this with some help from the ManageWP support team.

For anyone looking to use this feature with Local Lightning you need to edit your wp-config.php file to include the mysql port specified under the database tab in local.

IE: define(‘DB_HOST’, “localhost:10023”);

After making this change the sync tools seem to be working pretty well.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.