Can't connect to remote DigitalOcean database I am attempting to connect an existing Drupal 8 site to a DigitalOcean managed Database.

The connection info I've received from DigitalOcean:

username = digitaloceanadmin
password = password
host = nameofmydbcluster.db.ondigitalocean.com
port = 25060
sslmode = REQUIRED


I've made the adjustments to settings.php:

$databases['default']['default'] = array (
  'database' =&gt; 'dbname',
  'username' =&gt; '...',
  'password' =&gt; '...',
  'prefix' =&gt; '',
  'host' =&gt; 'dbclustername.db.ondigitalocean.com',
  'port' =&gt; '25060',
  'namespace' =&gt; 'Drupal\\Core\\Database\\Driver\\mysql',
  'driver' =&gt; 'mysql',
);


However, I'm getting the following error:

PDOException: SQLSTATE[HY000] [2054] The server requested authentication method 
unknown to the client in ...


More errors when I drush cr:

In Connection.php line 416:

  SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client


In Connection.php line 416:

  PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]


I am running Drupal 8.8.1 with php7.2. The DB version on remote is MySQL 8.

Any help would be greatly appreciated.
I was able to resolve this from the info found here:

https://skoop.dev/blog/2019/10/04/PHP-and-the-DigitalOcean-MySQL-cluster/

The problem stemmed from the default authentication method for MySQL v8 is caching_sha2_password, which the article above suggests is not supported by php yet.

As the article suggests, we can switch back to the old authentication method with the following query:

ALTER USER 'myuser'@'%' IDENTIFIED WITH mysql_native_password BY 'thepasswordyouwant';


After making this alteration to the dbuser, I was able to connect to the digitalocean database without issue.