.net配置连接mysql数据库

<configuration>
  <connectionStrings>
    <add name="MySQLConnection" connectionString="server=localhost;port=3306;database=mydb;uid=username;password=password" providerName="MySql.Data.MySqlClient" />
  </connectionStrings>
</configuration>

using System;
using System.Data;
using MySql.Data.MySqlClient;

class Program
{
    static void Main()
    {
        string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MySQLConnection"].ConnectionString;
        MySqlConnection connection = new MySqlConnection(connectionString);

        try
        {
            connection.Open();

            // 在此处进行数据库操作

            connection.Close();
        }
        catch (Exception ex)
        {
            Console.WriteLine("连接数据库失败：" + ex.Message);
        }
    }
}