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 afterTo 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.
Click Edit Driver Settings to change driver library.
Delete existing mysql-connector by clicking Delete.
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.
