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
- These guidelines are intended for upgrade PhpMyAdmin on Linux
- SSH client like Putty and proper knowledge to use it.
- Some basic knowledge about common Linux commands.
- 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.