Problems after upgrade to PHP 5.4


after upgrading to PHP 5.4, I get

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

I tried resetting the password, but it didn’t help. How to fix this?

Check out this thread on Stack Overflow and see if it helps with your issue:

What do I do, if the DB is at a web hoster? What can I do in this case?

Do you have access to a control panel or other set up for your database? If not, I would contact their support and let them know about needed to update your password to the more secure one and maybe hint to them that it’s time to upgrade their MySQL installation (latest version is 5.6, I’m using 5.5.29 on my install) as the newer password setup has been around for a number of years now.

Have you got an easier solution?

Contact your web host, not a piwik issue (make sure to update your password in your config/config.ini.php if needed)