1)官方下载驱动:https://dev.mysql.com/downloads/connector/net/
下载完成后需要解压
2)打开VS2010引用驱动
在解压后驱动目录下找到MySql.Data.dll
4)使用代码连接连接数据库
引入命名空间:
using System.Data;
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using MySql.Data.MySqlClient;
namespace DatabaseConnection
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
MySqlConnection mconn = null;
mconn = new MySqlConnection("server=主机名;user id=用户名;Password=密码;database=数据库名称;persist security info=False");//创建对象
MySqlCommand mcmd = new MySqlCommand();//创建MySqlCommand对象
mcmd.Connection = mconn;
try
{
mconn.Open();
Response.Write("数据库连接成功");
}
catch
{
Response.Write("数据库连接失败");
}
finally
{
mconn.Close();
}
}
}
}
运行结果