I am trying to connect an existing Drupal 8 site to a database managed by DigitalOcean.
The connection information I received from DigitalOcean:
username = digitaloceanadmin password = password host = nameofmydbcluster.db.ondigitalocean.com port = 25060 sslmode = REQUIRED
I have made the settings to settings.php:
$databases('default')('default') = array ( 'database' => 'dbname', 'username' => '...', 'password' => '...', 'prefix' => '', 'host' => 'dbclustername.db.ondigitalocean.com', 'port' => '25060', 'namespace' => 'Drupal\Core\Database\Driver\mysql', 'driver' => 'mysql', );
However, I receive the following error:
PDOException: SQLSTATE(HY000) (2054) The server requested authentication method unknown to the client in ...
More mistakes when I
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 remote DB version is MySQL 8.
Any help would be highly appreciated.