ADO.NET连接MYSQL

先拓展mysql的插件

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace adoNet
{
    static class Program
    {
        /// <summary>
        /// 应用程序的主入口点。
        /// </summary>
        [STAThread]
        static void Main()
        {
            MySqlConnection mysqlCon = null;
            try
            {
                String con = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
                mysqlCon = new MySqlConnection(con);
                mysqlCon.Open();
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }finally
            {
                mysqlCon.Close();
            }
         
    }
    }
}

在配置文件中插入数据库信息connectionStrings
<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />
    </startup>
    
	<connectionStrings>
		<add name="conn" connectionString="server=1xx.xx.xx.xx;port=13xx6;Database=my_test;UID=root;PWD=xxxxx" providerName="MySql.Data.MySqlClient"/>
	</connectionStrings>

  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Runtime.CompilerServices.Unsafe" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-5.0.0.0" newVersion="5.0.0.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>