vs2013 mysql5.7_C#(VS2013)连接MySQL 5.7

安装mysql

版本5.7，之前有试过最新版8.22的，不过连接不成功，提示版本需要更新

所以下载mysql5.7 MSI版本：

安装注意：选择安装全部，因为包含了sql workbench；设置root密码统一密码，可再添加账户和密码

C#连接代码

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace ConnectMySql

{

public partial class Form1 : Form

{

///

/// 连接或断开数据库的全局变量

///

MySqlConnection connection = null;

MySqlConnectionStringBuilder conn_string = null;

///

/// 连接数据库填充參數

///

///

public void ConnectionDB()

{

conn_string = new MySqlConnectionStringBuilder();

conn_string.Database = "world";

conn_string.Server = "localhost";

conn_string.Port = 3306;

conn_string.UserID = "Delta";

conn_string.Password = "delta.123";

conn_string.ConnectionTimeout = 200;//超时时间

conn_string.ConnectionLifeTime = 200;

connection = new MySqlConnection(conn_string.ToString());

connection.Open();

}

///

/// 关闭数据库

///

public void CloseConn()

{

connection.Dispose();

connection.Close();

}

public Form1()

{

InitializeComponent();

}

public DataTable ExportToDataTable(string sql) //返回DataSet对象

{

ConnectionDB();

DataTable dt = new DataTable();

MySqlDataAdapter da = new MySqlDataAdapter(sql, connection);

da.Fill(dt);

return dt;

}

private void button2_Click(object sender, EventArgs e)

{

try

{

dataGridView1.DataSource = ExportToDataTable("SELECT * FROM world.country;");

}

catch (Exception ex)

{

MessageBox.Show(ex.ToString());

}

}

}

}