在 .NET 6 中使用 Dapper Framework 未能成功连接到 MySql

我已经使用.NET6环境创建了一个Web MVC视图项目，但在try 连接到数据库时遇到错误. 我介绍了包MySql.Data(8.1.0).

MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user 'root'@'localhost' (using password: YES) at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync)个

下面是appsettings.json文件中的MySQL配置参数.

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionString": "server=localhost;port=3306;database=test;user=root;password=root;"
}

以下是Program.cs代码

MySqlDBHelper.DB_CONNECTION_STRING = app.Configuration["ConnectionString"];

我确信我的数据库帐户密码设置不正确

我try 过调试 以确保Conn正确获取DB_CONNECTION_STRING数据. 下面是控制器的Add方法

        [HttpGet("Add")]
        public object Add(string FileName, string FilePath,string ImageUrl)
        {

            var sql = "INSERT INTO image_info (FileName, FilePath, ImageUrl) VALUES (@FileName, @FilePath, @ImageUrl)";


            using var conn = MySqlDBHelper.GetSqlConnection();

            conn.Open();
            var result = conn.Execute(sql, new { FileName, FilePath, ImageUrl });
            return Ok();
        }