C#访问MySql数据库

前提：

1. MySql已安装好，用户访问权限也设置成功。

注： 每个用户名访问mysql都用两种权限：本地权限和远程权限。

要赋予全部权限给某个用户，sql语句为:   

GRANT ALL PRIVILEGES ON [表1].*  TO siu20@"%"   IDENTIFIED BY 'something' WITH GRANT OPTION; 

 

下载：

1. Mysql-connector-net-5.0.3 

 

代码：

 using System;using System.Collections.Generic;using System.Text;using MySql.Data.MySqlClient;namespace CSDB{ class MySQLResults { public MySQLResults(string sql) { MySqlConnection conn = null; MySqlCommand command = null; MySqlDataReader reader = null; try { conn = new MySqlConnection("Server=localhost;User Id=baolu;Password=baolu;Persist Security Info=True;Database=baolu_db"); command = conn.CreateCommand(); command.CommandText = sql; conn.Open(); reader = command.ExecuteReader(); while (reader.Read()) { Console.WriteLine(reader[0]); Console.WriteLine(reader[1]); Console.WriteLine(reader[2]); } } catch (MySqlException se) { Console.WriteLine("Database operation errors : " + se.StackTrace); conn.Close(); command = null; reader.Close(); } } }}