Base solution for your next web application
Ends in:
01 DAYS
01 HRS
01 MIN
01 SEC
Open Closed

Connecting to mysql database with VS2017 tool #6748


User avatar
0
michaelvanderveeke created

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)
  • User Avatar
    0
    maliming created
    Support Team

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