I made a search for my problem and it seems that the best way will be to downgrade XAMPP. I am currently running version 1.8.1 and script was made about 2-3 years ago which means that version is not important to me.
I have some local PHP script which is connecting to local database and also to external remote database on shared hosting. On old computer I had older version of XAMPP (not currently sure which it was) and now while making database connection with new XAMPP version I receive this error
- Code: Select all
Warning: mysql_connect(): 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 C:\xampp\htdocs\xxxxxxxxxxxxx\db.php on line 13
I believe it means that there were some changes in new versions of MySQL and PHP but as the connection is on shared hosting, I cannot make changes as this description asks me to do or other solutions found while Googling.
I also searched how to downgrade properly but could not found some straightforward details.
Could you point me with some link where I can read instructions about proper downgrade?
I would also ask for pointing me to which XAMPP version is the latest stable and still working for my script.
Thank you
Best regards
Goran
P.S. Please add 1.8.1 version to profile drop-down.