title: Error: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
body: <p>I am getting the following error:</p>
  
  <blockquote>
    <p>Database connection failed: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command <code>SET PASSWORD = PASSWORD('your_existing_password')</code>.</p>
    
    <p>This will store a new, and more secure, hash value in <code>mysql.user</code>. If this 
        user is used in other scripts executed by PHP 5.2 or earlier you might 
        need to remove the old-passwords flag from your <code>my.cnf</code> file</p>
  </blockquote>
  
  <p>I using PHP 5.3.8 and MySQL 5.5.16 on my local machine and my host (media temple) is running PHP 5.3 MySQL 5.0.51a.  The version on the live server is older than the one on my machine.</p>
  
  <p>How do I fix this error and connect to MySQL from my local machine?</p>
  
  <p>I know there are similar posts to this one but I have tried them all and none are working. </p>