mysql判断是否连接_判断C#连接mysql是否成功

public MySqlConnection con()

{

string database = "abc";

string local = "127.0.0.1";

string user = "root";

string password = "123";

//"Database='"+database+"';Data Source='"+local+"';User Id='"+user+"';Password='"+password+"'"

MySqlConnection con = new MySqlConnection("Database = '" + database + "';Data Source = '" + local + "';User Id = '" + user + "';Password = '" + password + "';Charset = 'utf8'");

con.Open();

if (con.State == ConnectionState.Open)

{

MessageBox.Show("数据库连接成功！");

con.Close();

}

else

{

MessageBox.Show("数据库连接失败！");

}

return con;

}