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:


sudo apt-get install php5-mcrypt

Then everything will just work fine :).

This entry was posted in Tech. Bookmark the permalink.

8 Responses to PhpMyAdmin problems after upgrading to Ubuntu Feisty

  1. cousa says:

    Thanks for the post, I was having the same thing.

  2. Gerry says:

    Thanks for the pointer. The problem was bugging me for several days and was getting lost in the various locations of phpmyadmin config files in the new versions. Now why did I not think of the missing php5-mcrypt esp. when I know that my Feisty install is not yet fully configured.

    Thanks to your quick post can carry on with life now ;-)

  3. Matthias says:

    Thanks for the tip! Now it works :o).

    Before I stumbled across your post I only read the “solution” to delete your cookies, which didn’t work for me.

    Thanks again!

  4. Andy says:

    Cheers mate, have been scratching my head over this for the past week.

  5. Mike says:

    You are the man. This has been driving me nuts.

  6. Daniel says:

    “There‚Äôs a very simple solution for this problem. This is:
    sudo apt-get install php5-mcrypt”

    Thank you so much for this, it has been driving me nuts, and I have been looking everywhere for a solution, it worked like a charm :)

  7. yo2k says:

    thanks. that is the best solution for me.

  8. Jeana says:

    That’s way more clever than I was epxecitgn. Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.