I ran into this problem when I tried to import my v5 project into v6. I develop on my home windows7 machine and connect remotely to my webserver mysql db on my hosting server. The hosting company has mysql Ver 5.1 +, but I got this error when trying to connect with V6 (PHP5.3):
Connection Error
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. 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 my.cnf file
I have found that some webhosts have left the default settings in mysql my.cnf file which is
This article explains the fix and why this happens with php 5.3:
http://lampsailesh.blogspot.com/2011_05_01_archive.html#5294498109303285481
Also mentioned here on the dev.mysql site:
http://dev.mysql.com/doc/refman/5.5/en/old-client.html
My question is; Will this be an issue when deploying a V6 application? Or will the apps run fine no matter how mysql is setup on the host?