Upgrade phpMyAdmin to latest version on Linux

phpmyadmin is free and an open source php platform used to administer MySQL with a web browser.It supports wide range of operations on MySQL, MariaDB. Through this user interface frequently used operations like (run MySQL queries, optimize, repair and check tables, change collation and execute other database management commands) can be performed .

Prerequisites

  1. These guidelines are intended for upgrade PhpMyAdmin on Linux
  2. SSH client like Putty and proper knowledge to use it.
  3. Some basic knowledge about common Linux commands.
  4. 20 minutes of your time with a cup of tea or coffee as always.

Step 1- Download Latest version of phpMyAdmin

Use the below command to download the latest version of phpMyAdmin into /opt or /usr/src directory

wget https://files.phpmyadmin.net/phpMyAdmin/4.5.5/phpMyAdmin-4.5.5
-all-languages.zip
unzip phpMyAdmin-4.5.5-all-languages.zip

Step 2- Find phpMyAdmin Installation Directory

Use the below command to search the phpMyAdmin Installation Directory on your system

find / -name "phpmyadmin"
/var/lib/mysql/phpmyadmin
/var/lib/phpmyadmin
/etc/phpmyadmin
/usr/share/lintian/overrides/phpmyadmin
/usr/share/doc/phpmyadmin
/usr/share/doc-base/phpmyadmin
/usr/share/dbconfig-common/data/phpmyadmin
/usr/share/phpMyAdmin

Step 3- Remove phpMyAdmin content

Just Delete/Remove everything from /usr/share/phpmyadmin directory.

cd /usr/share/phpMyAdmin/
rm -Rf *

Step 4- Move New phpMyAdmin content

Use the below command to copy all the new phpMyAdmin content to /usr/share/phpmyadmin.

cd /opt/phpMyAdmin-4.5.5-all-languages
mv * /usr/share/phpMyAdmin/

Now restart Apache, MySQL or MariaDB service.

Start/Restart the service in SysVinit Systeme
service restart httpd
service restart mysql

Start/Restart the service in Systemd Systeme
systemctl restart httpd.service
systemctl restart mariadb.service

So this is all you have to do, Also read about Install PhpMyAdmin On Fedora, CentOS & RHEL With Apache Web Server. Please Give your opinion below if you experience any issues or to discuss your ideas and experiences.

Leave a Reply