DB Connect Error

[balcv]

I am attempting to setup DB Connect to talk to a MySQL database on my Redhat Linux server.
I have installed the MySQL jar file on the Splunk server, MySQL driver is showing as available, firewall rules are taken care of so connectivity is fine, however when I save the New Connection information, I get:

Database Connection [name] is invalid.
CLIENT_PLUGIN_AUTH is required

Running MySQL 5.1.73
Splunk MySQL driver is ver 8.0
mysql-connector-java-8.0.12.jar

Can anyone help me out with the resolution to this one?

Many thanks

[rpille_splunk · Accepted solution]

Try using an older .jar file. Go to https://dev.mysql.com/downloads/connector/j/ and click "Looking for previous GA versions?"

According to the DB Connect documentation, the tested version was 5.1. https://docs.splunk.com/Documentation/DBX/3.1.4/DeployDBX/Installdatabasedrivers#Supported_databases

[balcv]

Thank you, yes it was version related. Once I did a Splunk restart, the "old" jar file was picked up and it all worked as required. Thanks

[balcv]

I have put an older version of the connector (mysql-connector-java-5.1.47.jar) in the /opt/splunk/etc/apps/splunk_app_db_connect/drivers folder but Splunk is still reporting MySQL v 8.0 in the drivers screen of DB Connect even after a Reload.
Do I need to restart splunk to pick up the different driver?

[balcv]

Tried an older version but same result. I suspect the issue may be on my database server side so not sure if there is something I need installed on that side.