连接字符串为c＃.net到mysql数据库连接

Question

有一个MySQL数据库存储在我的服务器在IP：50.62.82.45，数据库的名称是：detail_admin，用户ID是：welcome，密码是：你好，那么什么连接字符串将是我访问和MySQL的服务器的数据库查询火

我都试过，但它不工作

server = "50.62.82.45"; 
      database = "detail_admin"; 
      uid = "welcome"; 
      password = "hello"; 
      string connectionString; 
      connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";"; 

      connection = new MySqlConnection(connectionString); 

（mysql-connector-net-6.0.7-src.zip）此驱动程序我用于连接

Answer 1

string myConnectionString = "SERVER=50.62.82.38;" + 
          "DATABASE=admin_urja;" + 
          "UID=welcome" + 
          "PASSWORD=hello;"; 
MySqlConnection connection = new MySqlConnection(myConnectionString);