Unable to create connection for MySQL 8

[Niels Hwiid 2]

Keep getting this eror:

Connection test failed: Authentication method 'caching_sha2_password' not supported by any of the available plugins.

Have already chenge the Authentication Type to "Standard"

Any idea how to get arround it

[Albert Baiungo Jr.]

Hi Niels,

The error message states that the password is not supported by any of the plugins. I would suggest to open a case with the TIBCO Scribe Support team and provide some additional information regarding the steps you are taking to create the connection and provide a screen shot of the error. If you would like me to open a case for you I would be happy to and then you could provide the information, or you may open one. Please let me know.

Kind Regards,

Albert

[Niels Hwiid 2]

Hi Albert,

Thank you for your reply.

I will do some further testing and then create a Case myself, if I do not get pass the error.

Thanks.

[Ash Arendsz]

Hi Niels,

1) With a fresh install of mysql 8 Community edition found here:https://dev.mysql.com/downloads/windows/installer/8.0.html

The installer has two options for Authentication method:

- Strong pwd Encryption andLegacy Auth method.

Choose Legacy and it will work similar to the other/ previous mysql server versions.

As you create new mysql user accounts, they will all be set to use the legacy authentication method by default.

 

2) If you already have your server setup up and running, if you switch the configuration options for

Default Authentication plugin = mysql_native_password.

and then restart your mysql server.

Your current mysql users may not work, but if you create a new mysql user account using Mysql workbench version 8, you will see the associated authentication method for the new user, it should be set to "Standard" and this will work with scribe online.

If you use a different mysql rdbms client for creating mysql accounts(other than Mysql workbench ver 8), you might get different results as they might create the new user account using the wrong default auth method.

 

As most mysql clients are not compatible yet with the newauthentication method, you can configure MYSQL server and mysql user accountsto the compatible authentication method for all your running mysql clients and apps and servers to share the same auth. method.

More info here:https://stackoverflow.com/questions/50088142/authentication-method-caching-sha2-password-not-supported-by-any-of-the-availarq=1

 

For more info on howto convert existing user account:

https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded

[Ash Arendsz]

unable-to-create-connection-mysql-8 or connection mysql 8