xcloner_database.ERROR: Access denied

Hi

I have a problem with database backups on one of my sites.

The site is a multisite, the database is on a remote server – different local IP.

Web Hosting server uses 192.168.0.1
MySQL server uses 192.168.0.2

I have another multisite, which has the same settings stored in the XCloner Backup Settings screen, that works fine.

The log shows the access denied error then creates an empty .sql file as follows:

#
# Powered by XCloner Site Backup
# https://www.xcloner.com
#
# Host: https://xxxxxxxxxxxx.com
# Generation Time: Dec 21, 2019 at 12:00
# PHP Version: 7.2.25
# Database Charset: utf8mb4
# MYSQL innodb_version: 5.7.24
# MYSQL protocol_version: 10
# MYSQL slave_type_conversions:
# MYSQL version: 10.2.19-MariaDB
# MYSQL version_comment: MariaDB Server
# MYSQL version_compile_machine: x86_64
# MYSQL version_compile_os: Linux
# MYSQL version_malloc_library: system
# MYSQL version_ssl_library: OpenSSL 1.0.1e-fips 11 Feb 2013
# MYSQL wsrep_patch_version: wsrep_25.23
#
# Database : dbname
# ——————————————————–

#
# Finished at: Dec 21, 2019 at 12:00
#

I infer from that that XCLoner has managed to read something from the remote server, but not the tables.

I noticed that the error message:

[2019-12-21 12:00:42] xcloner_database.ERROR: Access denied for user ‘dbname’@’192.168.0.1’ to database ‘dbname’ [“”] []

is quoting the WordPress server local IP 192.168.0.1, not the MYSQL server IP 192.168.0.2, which is stored correctly in the XCloner Backup Settings screen.

Thanks!