PhpMyAdmin problems after upgrading to Ubuntu Feisty

Just a quick post about a problem I had a few days ago.

I noticed after upgrading to Ubuntu Feisty from Ubuntu Edgy the last time, PhpMyAdmin didn’t work anymore. I got the following error:

#1045 - Access denied for user: 'www-data@localhost' (Using password: YES)

I searched around on the internet but couldn’t find a solution. Logging in via the MySQL prompt went fine. I reinstalled mysql-server-5.0, I reinstalled PhpMyAdmin but still no go. After disabling passwords with:

/usr/bin/mysqld --skip-grant-tables

Things still didn’t work. My username got encrypted in a weird kind of way after logging in. When logging in PhpMyAdmin just redirected me to the login screen.

There’s a very simple solution for this problem. This is:

[ad#hoofdbanner]

sudo apt-get install php5-mcrypt

Then everything will just work fine :).