C#-连接Mysql数据库

1.预备工作

mysql 要开放权限，允许远程连接，这个不再赘述

导入mysql.data包依赖

若没有，项目->右键->包管理器->浏览，搜索，安装

代码

using System;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace mysql
{
    class Program
    {
        static void Main(string[] args)
        {

            //1.创建连接
            MySqlConnection con = getConection();
            //2.连接
            con.Open();
           //3.sql语句
            string sql = "select * from user";
           //4.根据sql和连接创建执行命令
            MySqlCommand command = new MySqlCommand(sql,con);
           //5.执行查询或更新
            MySqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                Console.WriteLine("{0}-{1}", reader.GetString("name"), reader.GetString("age"));

            }
        }

        public static MySqlConnection getConection()
        {
            //设置mysql的ip、用户名、密码和要连接的数据库
            MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
            builder.Server = "182.92.200.149";
            builder.UserID = "root";
            builder.Password = "LTX";
            builder.Database = "test";
            //实例化MysqlConnection对象
            MySqlConnection con = new MySqlConnection(builder.ConnectionString);
            return con;
        }
    }
}

效果