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.
P.S. Please add 1.8.1 version to profile drop-down.