C# 连接MySQL数据库

如果连接失败

SslMode = none;   在连接字符后追加;SslMode = none;

 string conna = $"server=127.0.0.1;database=fi601;uid=root;pwd=123456;SslMode = none;";

如果查询语句或者表名有中文一定要加上CharSet=utf8

 string conna = $"server=127.0.0.1;database=fi601;uid=root;pwd=123456;SslMode = none;CharSet=utf8";

string sql = "server=127.0.0.1;database=ramanager;uid=root;pwd=root;SslMode = none;";//如果连接不上    ;SslMode = none;  加上这个
            MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(sql);
            conn.Open();
            MySql.Data.MySqlClient.MySqlCommand comm = new MySql.Data.MySqlClient.MySqlCommand();
            comm.Connection = conn;
            comm.CommandText = "select count(*) from s_cert where username='" + USERNAME + "' and time='" + day + "' and caozuo='申请并下载'";
            //comm1.CommandText = "select count(*) from s_cert where username='" + USERNAME + "' and time='" + day + "' and caozuo='更新并下载'";
            string num = comm.ExecuteScalar().ToString();
            conn.Close();

            label28.Text = num;