Error creating new site with a remote database (Plugin caching_sha2_password could not be loaded)

[eduardo-veras]

Hi there!

I'm trying to create a new site with a remote database using the following command:

$ ee site create www.mydomain.com --type=wp --ssl=le --cache --dbhost=db.myhost.com:3306 --dbname=mydb --dbuser=myuser --dbpass=mypassword

Note: I changed my original values for samples

And I'm getting this output:

Starting site creation.
Configuring project.
Verifying connection to remote database
Success: Connection to remote db verified
Creating WordPress site www.mydomain.com
Copying configuration files.
Starting site's services.
Downloading and configuring WordPress.
Warning: Couldn't connect to db.myhost.com:3306 or there was issue in `wp config create`. Please check logs.
Warning: Initiating clean-up.
[www.mydomain.com] Docker Containers removed.
[www.mydomain.com] site root removed.

Checking the /opt/easyengine/logs/ee.log, I found the following:

[28-10-2021 14:57:22] ee.DEBUG: -----------------------  
[28-10-2021 14:57:22] ee.DEBUG: COMMAND: docker-compose exec --user='www-data' php wp config create --dbuser='myuser' --dbname='mydb' --dbpass='mypassword' --dbhost='db.myhost.com:3306'  --dbcharset=utf8mb4 --extra-php="if ( isset( \$_SERVER['HTTP_X_FORWARDED_PROTO'] ) && \$_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https' ) { 	\$_SERVER['HTTPS'] = 'on'; }  // Enable WP_DEBUG mode. define( 'WP_DEBUG', false );  // Enable Debug logging to the /wp-content/debug.log file define( 'WP_DEBUG_LOG', false );  // Disable display of errors and warnings. define( 'WP_DEBUG_DISPLAY', false ); @ini_set( 'display_errors', 0 );  // Use dev versions of core JS and CSS files (only needed if you are modifying these core files) define( 'SCRIPT_DEBUG', false );"  
[28-10-2021 14:57:24] ee.DEBUG: STDOUT: ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory   
[28-10-2021 14:57:24] ee.DEBUG: RETURN CODE: 1  
[28-10-2021 14:57:24] ee.DEBUG: ----------------------- 

If I try to create a site with a local database, that works normally.
So I know that I can install locally, create a dump, restore the dump on the remote database, and change the wp-config.php to point to the remote host, but I'm trying to avoid this.

My guess is the ee is sees that it's a remote database and then is not loading all necessary plugins.

Any ideas? :)

My environment:
OS: Ubuntu 20.04.3 LTS (Digital Ocean Droplet)
EE: 4.3.1
Docker: 20.10.10

Thank you in advance for any help!