mysql设置身份验证设置,MySQL将身份验证类型从标准更改为caching_sha2_password

I've setup a new MySQL instance on a computer and every time I add a user it sets the Authentication Type to caching_sha2_password.

This happens even if I set the Authentication Type to "Standard", it then changes it when I save the user. I've also changed the default authentication plug in to "mysql_native_password", but it still keeps doing it.

With it using the caching_sha2_password I can't connect to the database from .net core as I get an error stating:

MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins

How do I get it to save users with the Standard authentication type?

解决方案

I had the same problem today. The only way I found to fix it was:

executing the install file

select "Reconfigure" over the mysql server

In Authentication Method tab, select "Use Legacy Authentication Method"

It should fix your problem.