MySQL probe - Client Does not support authentication protocol

book

Article ID: 207178

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

When you configure the MySQL probe v1.54 to connect on MySQL 8.x server with strong password encryption (caching_sha2_password_authentication) enabled, the following error is displayed:

"Client Does not support authentication protocol requested by server; consider upgrading MySQL Client"

Cause

Currently, the MySQL Probe uses MySQL connector version 6.0.2 which doesn't have the support for caching_sha2_password_authentication.

Environment

MYSQL probe 1.54

 

Resolution

To support the caching_sha2_password_authentication the probe must have the embedded MySQL connector upgraded to 8.0.7 version  or higher.

An enhancement request was accepted for this, and the tentative ETA for this is the later half of 2021.

By now, the only workaround possible is described in the below articles for MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client:

https://medium.com/codespace69/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server-consider-8afadc2385e2

https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server