When installing a new MySQL agent, the message "CLIENT_PLUGIN_AUTH" is required occurs when connecting to a MySQL 5.1.5.1 instance.
CAUSE 1
The MySQL driver no longer supports 5.1.
Beginning with the 5.9.3.10 cartridge, the supported MySQL versions are now 5.5, 5.6, 5.7, and 8.0.
CAUSE 2
host cache issues on the MySQL instance
RESOLUTION 1
Download and unpack the 5.7.5.96 MySQL cartridge (attached to this KB). This cartridge can be installed concurrently with newer cartridges in the FMS.
It uses the JDBC Connector/J driver 5.1.39 and is the highest supported version for MySQL 5.1 databases.
Note: Some customers have found that the MySQL 5.9.2.1 cartridge (which used the 5.1.42 JDBC Connector/J driver) will successfully monitor MySQL 5.1 databases.
RESOLUTION 2
For databases above 5.1, running the FLUSH HOSTS command may help monitoring to be re-established.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center