连接mysql需要安装mysql,在mysql的C盘安装目录有一个连接 lib,将改lib添加引用用项目OK;
 static void Main(string[] args)
        {
            List<string> lstdb =MySqlConn();
            foreach (string s in lstdb)
            {
                Console.WriteLine(s);
            }
            Console.Read();
        }
        public static List<string> MySqlConn()
        {
            List<string> lstconn = new List<string>();
            MySqlConnection objConn = new MySqlConnection();
            objConn.ConnectionString = "server=127.0.0.1;User Id=root;Password=000000;Persist Security Info=True;database=test ";
            objConn.Open();
            MySqlCommand objCmd = new MySqlCommand("select * from maya", objConn);
            MySqlDataReader dr = objCmd.ExecuteReader();
            while (dr.Read())
            {
                lstconn.Add(dr[0].ToString());
            }
            objConn.Close();
            return lstconn;
        }
    }