当我尝试将 MySQL (8.0) 数据库与 Visual Studio 2018 连接时,我收到此错误消息
When I try to connect MySQL (8.0) database with Visual Studio 2018 I get this error message
任何可用插件都不支持身份验证方法'caching_sha2_password'"
"Authentication method 'caching_sha2_password' not supported by any of the available plugins"
我也无法检索数据库名称.我使用 mysql-for-visualstudio-1.2.7
和 mysql-connector-net-8.0.11
进行连接.有什么办法可以解决.
Also I am unable to retrieve Database name.
I use mysql-for-visualstudio-1.2.7
and mysql-connector-net-8.0.11
for connection.
Is there any possible way to fix it.
我在尝试将客户端计算机连接到服务器时遇到了同样的错误.我必须连接到服务器上托管的 MySQL 服务器.我已经开始工作了.遵循以下步骤:
I faced the same error while i was trying to connect my client machine to the Server. I had to connect to MySQL server hosted on the Server. I have got this to working. Followed the following steps:
现在在解决方案探索->参考->添加参考->转到程序集 tsb->扩展->搜索 mysql.data.dll(确保它在那里)->检查该选项.请注意,本例中 mysql.data.dll 的版本为 8.0.18.0.
Now in Solution Explore->References->Add References->Go to Assemblies tsb-> Extensions->Search for mysql.data.dll(make sure that its there)->check that option. Please note that mysql.data.dll is of version 8.0.18.0 in this case.
这篇关于任何可用插件都不支持身份验证方法“caching_sha2_password"的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!