Connection Errors Using MongoBI with JDBC MySQL 8.x Driver on MicroStrategy 2019 Mac Desktop or WorkStation

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Symptom

When a user tries to connect to MongoBI with JDBC driver on Mac Desktop/WorkStation, a CLIENT_PLUGIN_AUTH is required error message appears.

Cause

The MySQL 8.x JDBC driver is not compatible with MongoBI because only MySQL 5.x JDBC is currently supported. 

Action

Add the MySQL 5.x JDBC driver and restart the application to ensure that the update can take effect.

Workaround

• Download the MySQL JDBC driver Connector/J and save the driver to a folder on your local machine.
• Open Desktop or WorkStation.
• Create a new dossier.
• Click New Data > MongoBI > Select Tables. 
• Click + to add a new data source.
• Select Add Driver from the Data Source dialog and navigate to the driver saved on your machine.
  

• Enter the Host name:Port number/Database Name.
  

• Click Save.
• Restart your Desktop or WorkSstation.