title: How to connect to Mysql using C#?
body: <p>I'm just a beginner in C#. I'm using XAMPP server for MySQL database and Visual C# 2010. Then I have created a database named "testdb" in phpMyAdmin and a table named "login". I have inserted my username and password in the table. I'm doing a simple WinForm login where I made two text boxes for username and password and a button. I have my codes done and there's no compiler error. But I had troubled in one line. It says "Unable to connect to any of the specified MySQL hosts". I added MySql.Data to my references. I want to fetch the data in the database table when I'm going to log in. Then authorize the user or if not matched, it will prompt an error message.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>using MySql.Data.MySqlClient; 
  
  public bool Login(string username, string password)
  {
      MySqlConnection con = new MySqlConnection("host=localhost;username…");
      MySqlCommand cmd = new MySqlCommand("SELECT * FROM login WHERE username='" +
                                        username + "' AND password='" + password + "';");
  
      cmd.Connection = con;
  
      con.Open(); // This is the line producing the error.
  
      MySqlDataReader reader = cmd.ExecuteReader();
  
      if (reader.Read() != false)
      {    
          if (reader.IsDBNull(0) == true)
          {
              cmd.Connection.Close();
              reader.Dispose();
              cmd.Dispose();
              return false;
          }    
          else
          {
              cmd.Connection.Close();
              reader.Dispose();
              cmd.Dispose();
              return true;
          }    
      }    
      else
      {
          return false;
      }    
  }
  </code></pre>
  
  <p>*I hope for your your feedback. :)</p>