using System;
using System.Data;
using MySql.Data.MySqlClient;
namespace ConsoleApp2
{
class Program
{
static void Main(string[] args)
{
string connection = "server=XXXXXXXXX;port=端口号;user id=用户名;password=密码;database=mysql;SslMode=none";
MySqlConnection conn = new MySqlConnection(connection);
string sqlQuery = "SELECT Db FROM columns_priv";
MySqlCommand comm = new MySqlCommand(sqlQuery, conn);//创建命令对象
conn.Open();//打开数据库链接
MySqlDataReader dr = comm.ExecuteReader();//执行命令
while (dr.Read())
Console.WriteLine(dr[0].ToString());//测试
conn.Close();
//return dr;
}
}
}
C#连接Mysql
最新推荐文章于 2024-09-12 15:39:41 发布
关键词由CSDN通过智能技术生成