title: Connect from C#.net to MySql database on host
body: <p>I have a problem with connecting to MySQL database on my host from my C#.net.</p>
  
  <pre><code>server = "server ip";//localhost in php
          database = "database name";
          uid = "username";
          password = "password";
          string connectionString;
          connectionString = "SERVER=" + server + ";" +"DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
  
          connection = new MySqlConnection(connectionString);
  
          public void Insert()
          {
          string query = "INSERT INTO Orders (id,name,age) VALUES('1', 'nika', '28')";
  
          //open connection
          if (this.OpenConnection() == true)
          {
              //create command and assign the query and connection from the constructor
              MySqlCommand cmd = new MySqlCommand(query, connection);
  
              //Execute command
              cmd.ExecuteNonQuery();
  
              //close connection
              this.CloseConnection();
          }
      }`
  </code></pre>
  
  <p>in my reference of MySQL.Data  in section "Copy Local" value is true.
  So anyone can please tell me what to type in server string?</p>