DBviewer: CLIENT_PLUGIN_AUTH is required

Table of Content

When trying to connect to MySQL from DBeaver as well as other client programs and services, the error CLIENT_PLUGIN_AUTH is required appears and the error may occur when the mysql-connector being used is outdated.

Driver downloading

The current connection driver of mysql does not support the lower version, the driver requirements:

com.mysql.jdbc.Driver <-- mysql-connector-java before 5 and 5
com.mysql.cj.jdbc.Driver <-- mysql-connector-java 6 and after

To solve the problem download the lower version of the driver from the MySQL official website https://downloads.mysql.com/archives/c-j/, then unarchive the file.

Driver downgrading in DBviewer

In particular, when the DB connection client program automatically installs the driver, the version may not match.
file

Click Edit Driver Settings to change driver library.
file

Delete existing mysql-connector by clicking Delete.
file

Add a connector compatible with the MySQL version you are using with Add File. Also, you need to change the Driver Class name accordingly, choose com.mysql.jdbc.Driver or com.mysql.cj.jdbc.Driver, it depends on which MySQL version you are using.

After applying and testing, you can confirm that it works normally.
file

Leave a Reply

Your email address will not be published. Required fields are marked *