title: What will happen to some connection with same connect string?
body: <p>Let say i have 4 MySQL connection and a connectString (I leave the connection pooling enabled, i'm using MySQL .NET Connector from MySQL itself)</p>
  
  <pre><code>protected internal MySqlConnection connection;
  protected internal MySqlConnection cnnct1,cnnct2,cnnct3;
  protected internal string connectString = "SERVER=" + addressBox.Text + ";DATABASE=" + dbNameBox.Text + ";UID=" + UserBox.Text + ";PASSWORD=" + PassBox.Text + ";";
  </code></pre>
  
  <p>Then i assign the connections</p>
  
  <pre><code>protected internal void connectionMaker()
  {
      connection = new MySqlConnection(connectString);
      cnnct1 = new MySqlConnection(connectString);
      cnnct2 = new MySqlConnection(connectString);
      cnnct3 = new MySqlConnection(connectString);
  }
  </code></pre>
  
  <p>What i will do with those connections is, since my App is multi-threaded and all thread require to access a single database concurrently at a same time so i think to give each thread different connection, but since they're all accessing to a same DB, even a same table so i think to give each connection same connect string.</p>
  
  <p>for addition each thread will be executing <code>MySqlReader</code> with <code>SELECT</code> command on same columns on a single table at same time (through Task Parallel Libary), but each of them will read different rows</p>
  
  <p>My questions are, i'm trying to make my code to be as simple and easy as possible, yet is this a safe, good, and correct practice ? if not, is there any simple yet safe approach to do what i'm going to do ?</p>