Hi. I am reshaping a system made with 6.1 and after I build it and try to test, I got this error:
Warning: mysqli_connect(): (HY000/2000): 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 in E:\xampp\htdocs\AMC\2013\comisiones\membresia\output\include\dbconnection.my.mysqli.php on line 12
Fatal 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 in E:\xampp\htdocs\AMC\2013\comisiones\membresia\output\include\dbconnection.my.mysqli.php on line 15
I already did the SET PASSWORD = PASSWORD('your_existing_password') in phpmyadmin and got no complain but the error is there.
My server is a shared one with Mysql Version 5.1.72-cll and php version is 5.2.9
The question is:
Do I have to do something in phpr in order to fix this or do I have to ask server support for this?
Thanks in advance for any ideas.