Forum

Thread tagged as: Problem, Error

Upgraded PHP 5.2 to 5.6 now database not found

I have just updated a client's server from running PHP 5.2 to PHP 5.6 so it can support Perch 2.8.18 and now when I go to the perch login it says database not found.

That database still exists and no details have changed. Please can someone offer some advice.
James Tedder

James Tedder 0 points

  • 5 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

5 years ago

Your host would be the person to speak to, that error isn't coming from Perch so we are not likely to be able to help much in this case.
James Tedder

James Tedder 0 points

5 years ago

I have just run a PERCH test and it mentions this:

SQLSTATE[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
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

Ok, great. Have you done that?
James Tedder

James Tedder 0 points

5 years ago

Solved it - I imported my old database into a new one and updated my config.