Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

After upgrading MySQL from 5.5 to 5.6 I got the following error in phpmyadmin:

Your PHP MySQL library version 5.5.33 differs from your MySQL server version 5.6.13. This may cause unpredictable behavior.

The problem would be solved by installing php5-msqlnd but the repository for Ubuntu 12.04 LTS didn't fix the issue as it says in this launchpad bug report

Installing via sudo apt-get install phpmyadmin will warn the user that php5-mysqlnd will be marked removed and php5-mysql will be marked install

this is the output I got from the command: sudo apt-get install phpmyadmin

> The following extra packages will be installed:   php5-mysql Suggested
> packages:   mysql-server The following packages will be REMOVED:  
> php5-mysqlnd The following NEW packages will be installed:  
> php5-mysql phpmyadmin

Thus I will loose mysqlnd which is the new improved driver for mysql api

The suggested workaround is to play with dependencies string which I don't like because it's not the right way to solve this issue.

How can I install phpmyadmin with mysqlnd to support mysql 5.6 in ubuntu 12.04 without playing with dependencies string in the package config

share|improve this question

The solution I found is to add a custom PPA and install phpmyadmin with mysqlnd without any problem like this:

sudo add-apt-repository ppa:nijel/phpmyadmin
sudo apt-get update
sudo apt-get install php5-mysqlnd

sudo apt-get remove  phpmyadmin --purge
sudo apt-get install phpmyadmin
share|improve this answer
sudo apt-get --purge --reinstall install phpmyadmin will do the work of the last two commands (and will avoid leaving the user without phpmyadmin if their Internet connection is interrupted, because necessary packages are downloaded before the purge operation is performed). – Eliah Kagan Sep 1 '14 at 21:28
On Ubuntu 14.04 I was able to install php5-mysqlnd without any additional repo. Also It was important to drop the phpmyadmin before reinstalling to get rid of Connection for controluser failed error. – billynoah May 21 '15 at 6:10

I solved this problem on Ubuntu 14.04 by uninstalling and re-installing phpMyAdmin:

sudo apt-get remove phpmyadmin  # Note: I did NOT purge the phpMyAdmin database
sudo apt-get install phpmyadmin

After re-installing the warning no longer appeared.

share|improve this answer
This can also be accomplished with sudo apt-get --reinstall install phpmyadmin. This has the benefit that, if files have to be downloaded for the reinstallation, they will be downloaded before the package is uninstalled. (That way, Internet connection problems won't leave the user without phpmyadmin.) – Eliah Kagan Sep 1 '14 at 21:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.