Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
2.5.5
-
Development tools: netcore3.1
Framework: sqlsugar 5.0.1,
Database connection driver: mysql8.0.22
mysql version: mysql8.0.16
maxscale version: maxscale 2.5.5
Description
When the .net programs are directly connected to the mysql database, all are normal, and there is no error reported for 1 million pressure tests, but the following errors are occasionally reported when connecting through maxscale:
SqlSugar.SqlSugarException: English Message : Connection open error . Authentication method '' not supported by any of the available plugins.
Chinese Message : 连接数据库过程中发生错误,检查服务器是否正常连接字符串是否正确,实在找不到原因请先Google错误信息:Authentication method '' not supported by any of the available plugins..
at SqlSugar.AdoProvider.GetDataSetAll(String sql, SugarParameter[] parameters)
at SqlSugar.AdoProvider.GetDataTable(String sql, SugarParameter[] parameters)
at IM.Admin.Controllers.TestController.getUser() in /home/jenkins/agent/workspace/Dev-YallaChat-NetCore-Admin-Build/IM.Admin/Controllers/TestController.cs:line 29
执行SQL错误:English Message : Connection open error . Authentication to host '192.168.1.x' for user 'ht_v1' using method 'mysql_native_password' failed with message: Bad handshake
Chinese Message : 连接数据库过程中发生错误,检查服务器是否正常连接字符串是否正确,实在找不到原因请先Google错误信息:Authentication to host '192.168.1.x' for user 'ht_v1' using method 'mysql_native_password' failed with message: Bad handshake. | select ui.user_id,ui.user_name,ui.id from iden_account ia
left join user_info as ui on ia.id = ui.user_id |
The mysql user account uses the standard authentication method:mysql_native_password
Not sure of the cause of the problem, please help