mysql-關(guān)于連接服務(wù)器端MySql數(shù)據(jù)庫，卻不能成功打開

 /// 
 /// 建立執(zhí)行命令語句對象 /// 
 ///  ///  ///  public static MySqlCommand getSqlCommand(String sql, MySqlConnection mysql) { MySqlCommand mySqlCommand = new MySqlCommand(sql, mysql); // MySqlCommand mySqlCommand = new MySqlCommand(sql); // mySqlCommand.Connection = mysql; return mySqlCommand; } /// 
 /// 查詢并獲得結(jié)果集并遍歷 /// 
 ///  public static bool Search(string load,string password ) { /* //連接數(shù)據(jù)庫 //server=這里寫服務(wù)器的IP地址;uid=數(shù)據(jù)登錄名;pwd=密碼;database=數(shù)據(jù)庫 String mysqlStr = @"Database=bbs;Data Source=59.74.169.59;User Id=bbs;Password=kjcxlab.com!@!@;pooling=false;CharSet=utf8;port=8080"; // String mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString; */ MySqlConnection mysql = getMySqlcon(); int i = 0; Console.WriteLine("46"); try { Console.WriteLine("56"); if (mysql.State == ConnectionState.Open) //檢查連接狀態(tài) { mysql.Close(); } Console.WriteLine("63"); mysql.Open(); //打開數(shù)據(jù)庫連接 string sqlSearch; Console.WriteLine("64"); if (IsEmail(load)) { sqlSearch = @"select * from bbs_common_member where email='" + load + "' AND password=MD5('" + password + "')"; } else { sqlSearch = @"select * from data where username='" + load + "' AND password=MD5('" + password + "')"; } MySqlCommand mySqlCommand = getSqlCommand(sqlSearch, mysql); i = Convert.ToInt32(mySqlCommand.ExecuteScalar()); } catch (MySqlException oe) { Console.WriteLine(oe.Message); } finally { if (mysql.State == ConnectionState.Open) mysql.Close(); } if (i != 1) { return false; } else return true; } /// 
 /// 建立mysql數(shù)據(jù)庫鏈接 /// 
 ///  private static MySqlConnection getMySqlcon() { //server=這里寫服務(wù)器的IP地址;uid=數(shù)據(jù)登錄名;pwd=密碼;database=數(shù)據(jù)庫 String mysqlStr = @"Database=bbs;Data Source=59.74.169.59;User Id=bbs;Password=kjcxlab.com!@!@;pooling=false;CharSet=utf8;Port=8080"; //String mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString; MySqlConnection mysql = new MySqlConnection(mysqlStr); return mysql; } public static bool IsEmail(string str) { string res = string.Empty; string expression = @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"; bool boo = new Regex(expression).Match(str).Success; return boo; }}