Ubuntu: How to upgrade PHPmyAdmin [revisited]



Question:

This question was asked previously, How to upgrade PHPmyAdmin

The answer given was

sudo apt-get update  sudo apt-get install phpmyadmin  

or

sudo apt-get update  sudo apt-get upgrade  

The version of phpmyadmin included in apt-get is 4.5.4, which was released January 28 2016.

In a response to this question one answer was to use use the personal archive which offers the following commands.

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

In my case that updated a lot of things, but, not specifically phpmyadmin, I needed the additional command

sudo apt-get update phpmyadmin  

This did successfully get past the version 4.5.4 limit, but, only updated to version 4.6.6 which was released January 23 2017.

As of this writing it does seem that manually downloading and copying using the vague instructions from docs.phpmyadmin.net is required.

Is there a more current repository for phpmyadmin than the PPA or is a manual install required?


Solution:1

I would use the personal archive for phpmyadmin if you really need the latest version. Mind though that there is a dependency (you need a newer php too):

PPA description

Latest phpMyAdmin packages - https://www.phpmyadmin.net/. Based on packages available in Debian.

There are some notable changes:


Solution:2

You can simply manually install the latest version of phpmyadmin.

Head over to https://www.phpmyadmin.net/downloads and download the latest version but make sure you have the compatible PHP and MySQL version as listed on the website.

Extract it to your server public folder and edit the config.inc.php file. Make sure your auth_type is cookie and host is whatever your host is. This setting will make you enter your username and password when logging in.

/*Authentication type*/  $cfg['Servers'][$i]['auth_type'] = 'cookie';  $cfg['Servers'][$i]['host'] = 'localhost';  


Solution:3

I just had to do this because of issues with php7.2 and receiving the error count(): Parameter must be an array or an object that implements Countable.

The version from apt was 4.5.4 and the ppa does not have the fixes for php7.2. My solution was to download the latest version from https://www.phpmyadmin.net/ and copy the files to /usr/share/phpmyadmin.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »