"digitalocean MySQL DB" (#2570218) / TMS-Plugins

Comments

Yaron Ben-Shabat started the conversation
October 14, 2020 at 10:03pm
Hello, trying to connect to Separate DB connection using digitalocean MySQL DB but i keep getting the following error:
"wpDataTables could not connect to mysql server. mysql said: There was a problem with your SQL connection - The server requested authentication method unknown to the client"
i suspect that it's related to setting within DO sslmode = REQUIRED
472
Isidora replied
October 16, 2020 at 8:12am
Hi Yaron,
Thank you for your purchase.
We didn't face such issue so far, but we found that users from DigitalOcean have same issue and here is one of the solutions that you can try.
https://stackoverflow.com/questions/52364415/php-with-mysql-8-0-error-the-server-requested-authentication-method-unknown-to
Kind Regards,

Isidora Markovic

wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs

You can try our wpDataTables add-ons before purchase on these sandbox sites:

Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Yaron Ben-Shabat replied
October 16, 2020 at 12:44pm
Thanks Milan, it's DB Cluster not sure if i can change these settings but, moved to RDS.
472
Isidora replied
October 19, 2020 at 9:56am
Hi Yaron,
Sorry for late response.

We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
You are welcome.
If you have any other issue or question please open a new ticket, and we will help you out.

Kind Regards,

Isidora Markovic

wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs

You can try our wpDataTables add-ons before purchase on these sandbox sites:

Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables