I have this same problem. This is my user table.

+---------+-----------------------+------+
| user    | plugin                | host |
+---------+-----------------------+------+
| doadmin | mysql_native_password | %    |
+---------+-----------------------+------+

I am able to connect with a Rails application, but not Wordpress.

I am also able to log in to the managed database server with Mariadb’s client, which originally gave me the caching_sha2_password error message before changing the plugin to mysql_native_password.

The wp-config settings are as follows.

      define('DB_USER', 'doadmin');
      define('DB_PASSWORD', 'VERY_GOOD_PASSWORD');
      define('DB_HOST', 'bestestimatepro-do-user-user-id-0.db.ondigitalocean.com:25060');

Hi @cuddlyogre

What is the error that you get when you try to with Wordpress?

I’ve just tested this and it went through very smoothly.

One thing that is coming to my mind is the fact that the 25060 port might be closed on your Wordpress droplet. Make sure that allow the outgoing tcp traffic on port 25060.

To test the connectivity try running this telnet command:

telnet your.managed.mysql.server.here 25060

If the connection fails then it is definitely due to your firewall.

Regards,
Bobby

This is the telnet response I receive.

J
8.0.16ATU=/    ]�V;~tZ= nu^caching_sha2_passwordConnection closed by foreign host.

This is the Wordpress error I receive

Warning: mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

doadmin is using mysql_native_password and I’m using it as the database credentials for Wordpress. I have created other users that use mysql_native_password with no success as well.

select Host,User,plugin from mysql.user where user = 'doadmin';
+------+---------+-----------------------+
| Host | User    | plugin                |
+------+---------+-----------------------+
| %    | doadmin | mysql_native_password |
+------+---------+-----------------------+

Hi, @bobbyiliev
I am trying the following sample code to connect to my managed database Mysql:

<?php
ini_set('display_errors', 1);
$servername = "<host_name>:25060";
$username = "<username>";
$password = "<password>";

echo "$username";
// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
echo "Connected successfully";
?>

Hi @surajjagtap

Thanks for sharing the snippet! I’ve tested this at my end and it seems to be working like a charm:

• First I created a new cluster and tested it with the default details and as expected I got the expected error:

php mysql-test.php

Warning: mysqli::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] in /root/mysql.php on line 9

• Then I ran the alter query:

ALTER USER doadmin IDENTIFIED WITH mysql_native_password BY 'my_pass_here';

• After that, I ran another test and it worked perfectly:

php mysql-test.php

doadmin
Connected successfully

Are you running this from your local PC? I might suggest creating a small new droplet and running the test from there just to make sure that there’s nothing on your current environment that is causing this strange behavior.

Regards,
Bobby

Hi @surajjagtap

Thank you for your clarification! In this case, I would suggest following this step by step guide here:

https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-managed-database-ubuntu-18-04

I’ve tested it at my end and I can confirm that it is working smoothly.

Hope that this helps! Let me know how it goes.

Regards,
Bobby