title: Connect to MySQL DB using ASP.NET Entity Framework
body: <p>I have my connection string set as </p>
  
  <pre><code>&lt;add name="myconn" connectionString="server=192.X.Y.Z;user id=myusername;persistsecurityinfo=False;database=mydatabasehere;port=3306;Password=mypassword;" providerName="MySql.Data.MySqlClient" /&gt;
  </code></pre>
  
  <p>and later this error appear:</p>
  
  <blockquote>
    <p>An exception of type 'MySql.Data.MySqlClient.MySqlException' occurred
    in MySql.Data.dll but was not handled in user code</p>
    
    <p>Additional information: Authentication to host '192.X.Y.Z' for
    user 'myusername' using method 'mysql_native_password' failed with
    message: Access denied for user
    'myusername'@'crlspr-myipaddresshere.myacc.net' (using password: NO)</p>
  </blockquote>
  
  <p>What will be the problem of this exception? 
  my connection seems to be ok since I just tested from <strong>MySQL Workbench</strong> as well in <strong>Visual Studio * Server Explorer</strong></p>
  
  <p>Why the error message get my ipaddress, 'myusername'@'crlspr-myipaddresshere.myacc.net'? maybe is a firewall problem. </p>