C#链接MySQL数据库

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;           //使用命名空间

namespace mysql1
{
    /// <summary>
    /// 在控制台应用程序下，测试C#链接MySQL数据库
    /// </summary>
    class Program
    {
        static void Main(string[] args)
        {
            MySqlConnection conn = null;
            //创建MySqlConnection对象，链接MySQL数据库
            conn = new MySqlConnection("Data Source=localhost;Initial Catalog=test;User ID=root;Password=mysql");
            conn.Open();        //调用Open()对象，打开对象
            if (conn.State.ToString() == "Open")
            {
                Console.WriteLine("链接到MySql数据库，链接成功！");
            }
            else
            {
                Console.WriteLine("连接失败！");
            }
            Console.ReadKey();
        }
    }
}