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.
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.
Edit Driver Settings to change driver library.
Delete existing mysql-connector by clicking
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.cj.jdbc.Driver, it depends on which MySQL version you are using.
After applying and testing, you can confirm that it works normally.