title: C# - Unexpected authentication method mysql_native_password exception
body: <p>I didn't see anything on this, but I've been trying for the longest time to get some practice with an SQL database. I tried MSSQL and was frustrated to no end, so I tried MySQL and got a bit further. The database seems to be up and running, and I even did a query to make a table. Although when trying to connect with Microsoft's C# Express edition I get the exception: "unexpected authentication method mysql_native_password" I know the password is correct. I'm even referencing MySQL.Data.dll. Here's my code, I get the exception on connection.Open().Can someone please help me out?</p>
  
  <pre><code>     public Form1()
       {
        MySqlConnection connection = new MySqlConnection("Data Source = localhost;          Initial Catalog = MySQL55; Integrated Security = SSPI; User ID = root; Password = &lt;REMOVED&gt;;");
  
          try
          {
              connection.Open();
          }
  
          finally
          {
              if (connection != null)
              {
                  connection.Close();
              }
          }
       }
  </code></pre>