MySQL将身份验证类型从标准更改为caching_sha2_password [英] MySQL changing authentication type from standard to caching_sha2_password

问题描述

我已经在计算机上设置了一个新的MySQL实例，每次添加用户时，它将Authentication Type(身份验证类型)设置为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.

即使我将身份验证类型"设置为"Standard"，也会发生这种情况，然后在保存用户时将其更改.我也将默认身份验证插件更改为"mysql_native_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.

使用它使用caching_sha2_password时，由于出现错误，我无法从.net核心连接到数据库.

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

MySqlException:任何可用插件均不支持身份验证方法'caching_sha2_password'

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:

1. 执行安装文件
2. 在mysql服务器上选择重新配置"
3. 在身份验证方法"标签中，选择使用旧式身份验证方法"

它应该可以解决您的问题.

It should fix your problem.

这篇关于MySQL将身份验证类型从标准更改为caching_sha2_password的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！