Ubuntu – how to upgrade phptheadmin after installing thesql 5.6

12.04MySQLphpmyadmin

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

Best Answer

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