title: MYSQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)
body: <p>when I tried to restore all database dump which is in 5.0 version to 5.6 version, it got restored and after that when I tried to reconnect, am getting the following error </p>
  
  <p><code>ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)</code>..</p>
  
  <p>I have tried adding the following lines in My.ini and restarted the service,but the issue persist till.</p>
  
  <pre><code>skip-grant-tables
  </code></pre>
  
  <p>The following link says its a bug in MYSQL.</p>
  
  <p><a href="https://github.com/santisaez/powerstack/blob/master/packages/mysql/mysql-powerstack-secure_auth.patch">https://github.com/santisaez/powerstack/blob/master/packages/mysql/mysql-powerstack-secure_auth.patch</a></p>
  
  <p>Do anyone have any fixes for this solution?</p>