Unanswered: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
Working on a little project in PHP, I got the following:
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 /usr/local/apache2/cgi-bin/selector.php on line 5
Error in connect: 2000
The database is not under my control, so I had to get in touch with the DBA (I think) and ask for assistance: re-hash the password using the PASSWORD() function, then FLUSH privileges. It made no difference. I asked then to CREATE a new USER with
... IDENTIFIED BY PASSWORD PASSWORD('my_password');
and still no luck.
What are my choices now? Is there any other function I could use to connect except mysql_connect/mysqli_connect which would work with the shorter hash? Or what other options might be available?