phpMyAdmin is one of the most used MySQL database administration and management web interfaces. With phpMyAdmin one can create, delete and modify databases, build and modify tables inside those databases, assign users to the databases alongwith the user permission levels, execute SQL statements and much more. However, upgrading phpMyAdmin in XAMPP Server in Windows or even in Linux system is not seamless always. Here is our effort to simplify the task.
Many of us are using phpMyAdmin, it can be form any distributions like XAMPP, LAMP, MAMP, WAMP or any other. Well, phpMyAdmin gets updated very often, and it is important to update phpMyAdmin so that you’ll not me missing the updates for fixing critical vulnerabilities.
If you ever got an alert that PHPmyadmin has an important update fixing critical vulnerabilities. I also noticed that the PHPmyadmin version in the latest XAMPP version is way out of date and I would like to update it to be safe.
In the xampp folder there should be an phpmyadmin folder. Inside this folder you will find the config.inc.php file. Backup this file to another folder (eg. your Desktop) and delete everything else in the phpmyadmin folder. Then download the latest version of phpmyadmin from phpmyadmin.net , extract it and copy all files/folders into the old phpmyadmin folder. Also copy back the saved config.inc.php. Now you should have the latest phpMyAdmin running.
Steps to Upgrade PHPMyAdmin in Windows XAMPP server
- Backup xampp\phpmyadmin\config.inc.php
- Delete everything in xampp\phpmyadmin
- Download phpmyadmin
- Unzip new PMA version
- Move new files into xampp\phpmyadmin
- Copy old config.inc.php into xampp\phpmyadmin
All done, now you have upgraded phpMyAdmin and can use updated version of phpMyAdmin for websites and web applications. If you experience some trouble in upgrading phpMyAdmin on any server, feel free to leave comment.