c#连接mysql数据库代码

using System;
using MySql.Data.MySqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "server=127.0.0.1;uid=username;pwd=password;database=databasename;";
        
        MySqlConnection connection = new MySqlConnection(connectionString);
        
        try
        {
            connection.Open();
            Console.WriteLine("Connected to MySQL database!");
            
            // 执行数据库操作，如查询、插入、更新等
            
            connection.Close();
            Console.WriteLine("Disconnected from MySQL database!");
        }
        catch (MySqlException ex)
        {
            Console.WriteLine("Error: " + ex.Message);
        }
    }
}