title: Authentication failed using method mysql_native_password
body: <p>Trying to connect to MySQL on my web host, using Connector/Net C#/WinForms in Visual Studio 2012 Update 3, but getting the below error message:</p>
  
  <blockquote>
    <p>Authentication to host '1.1.1.1' for user 'username@mydomain.com' using method 'mysql_native_password' failed with message: Access denied for user 'username@mydomain.com'@'2.2.2.2' (using password: YES)</p>
  </blockquote>
  
  <pre><code>string connectionString = "SERVER=1.1.1.1;PORT=3306;DATABASE=databaseName;UID=username@mydomain.com;PASSWORD=mypassword;";
  
  MySqlConnection connection = new MySqlConnection(connectionString);
  connection.Open();
  </code></pre>
  
  <p>I am connecting remotely, have whitelisted my IP (and even temporary whitelisted all (%) to test), triple checked the username and password and IP. </p>
  
  <p>I originally tried the username without the domain (    username rather than    username@mydomain.com) but it gave me the below error:</p>
  
  <blockquote>
    <p>Authentication with old password no longer supported, use 4.1 style passwords.</p>
  </blockquote>
  
  <p>Any assistance would be much appreciated, thanks!</p>