TIBCO Spotfire Oracle MySQL Connector is not able to connect to MySQL Database.

TIBCO Spotfire Oracle MySQL Connector is not able to connect to MySQL Database.

The following is the error message which is present in the Spotfire Analyst logs
------------------------------------------
MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication with old password no longer supported, use 4.1 style passwords.
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at Spotfire.Dxp.Data.Adapters.MySql.MySqlAdapterConnection.ConnectAndGetDatabaseNames(String connectionString, List`1& databases)
-------------------------------------------
The original hashing algorithm used by MySQL (prior to 4.1) has been deemed to be unsecure. Version 4.1 implements a new hashing algorithm. The password in your connection string does not need to be hashed, the hashing is performed internally in your .Net connector during authentication to the database (it is done for you). The problem is if you have upgraded your database from a pre-4.1 version and not reset the password to use the new hashing.

To get the Spotfire Analyst/Client logs:

1. Open Spotfire Analyst/Client.
2. Browse to "Help > Support Diagnostics and Logging" > Logging tab
3. Set the Log level to "Debug" and make a note of the "Log file" location
4. Click on OK button.
5. Replicate the issue and then open the "Log file" path to open the "Spotfire.Dxp.SupportDiagnostics.log" file.
  You can do either of two things to rectify the situation. These scripts are run at the database.

To allow the database to accept the old style hash run

SET old_passwords=TRUE

OR

Set a new password using the new hashing

SET old_passwords=FALSE
SET PASSWORD=PASSWORD('your_new_password_here') https://stackoverflow.com/questions/15772479/authentication-with-old-password-no-longer-supported-use-4-1-style-passwords