MySQL Server connector test error "Authentication method 'caching_sha2_password' not supported error--I'm unfamiliar with this error. What causes this and what can I investigate

[Mario Meo]

MySQL Server connector test error "Authentication method 'caching_sha2_password' not supported error--I'm unfamiliar with this error. What causes this and what can I investigate

 

See also similar question andpossible solution here:

https://community.tibco.com/questions/unable-create-connection-mysql-8

[Manoj Chaurasia]

Hello Mario,

 

This error comes from MySQL and is a new way of authentication since version 8.

Are your clients version(s) before 8.0 or not

 

Below are few useful URLs I found relevent:

 

https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugi...

 

https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authenticatio...

 

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.h...

 

With regards,

Marzieh

[Ash Arendsz]

See also similar question and possible solution here:

 

https://community.tibco.com/questions/unable-create-connection-mysql-8

[Ash Arendsz]

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