Connecting to mysql database with VS2017 tool #6748

michaelvanderveeke created 5 years ago

Hello,

I'm trying to connect to a mysql database and I keep getting an error "Connection Failed! Details: Authentication method 'caching_sha2_password' not supported by any of the available plugins. "

Now I have changed the settings in the my.ini from "caching_sha2_password" to" mysql_native_password" and it still comes up with this error.

Any ideas?

1 Answer(s)

0

maliming created 5 years ago
Support Team

You can refer to: https://tableplus.io/blog/2018/07/failed-to-load-caching-sha2-password-authentication-plugin-solved.html

Have an answer to this question? Log in and write your answer.