MYSQL JDBC Data Source connection fails with the error: “CLIENT_PLUGIN_AUTH is required” in TIBCO Spotfire Analyst

MYSQL JDBC Data Source connection fails with the error: “CLIENT_PLUGIN_AUTH is required” in TIBCO Spotfire Analyst

Fail to create or edit MYSQL JDBC Data Source connection, using the Spotfire analyst client Information services with the error: “CLIENT_PLUGIN_AUTH is required” Check if the version of JDBC driver is compatible with the MYSQL DB version e.g. check if you are using a new version of the MYSQL JDBC driver which may not be compatible with the old version of MYSQL database.
For version 10.3 and above the JDBC driver is copied to the <Spotfire Server Install>\tomcat\custom-ext folder

For 10.2 and below the JDBC driver is copied to  the <Spotfire Server Install>\tomcat\lib folder

  https://stackoverflow.com/questions/37348572/new-mysql-driver-causes-java-sql-sqlnontransientconnectionexception-client-plug