update
FeaturedGuideHighlightsWindows

How to update phpMyAdmin on WAMP

Introduction

How to update phpMyAdmin on WAMP ? This tutorial provides step-by-step guidance on updating phpMyAdmin on WAMP to version 5.2.0, which is the latest version available at the time of writing.

Whether you use WAMP or another Windows web development environment, this guide can be easily adapted to upgrade your phpMyAdmin installation.

Follow this guide “How to Update PHP in WAMP” if you want to know how to update PHP on WAMP server.

How to update phpMyAdmin on WAMP

Firstly, go to https://www.phpmyadmin.net/, then download the latest version. Then, unzip the file to a new folder. In my case, since I’m using WAMP server, I will unzip it under “C:\wamp64\apps\phpmyadmin5.2.0”.

Then, copy the file “config.inc.php” from your old phpMyAdmin folder to the new phpMyAdmin Folder.
In this case, I’m upgrading from version 5.1.1 to 5.2.0. So, I’m moving the config.inc.php file from “phpmyadmin5.1.1” to the “phpmyadmin5.2.0” folder.

update phpMyAdmin

Then, open up “phpmyadmin.conf” file under the “C:\wamp64\alias” folder. Then, change the phpMyAdmin path to the new phpMyAdmin folder.

update phpMyAdmin

Here, I’ll be changing “Alias /phpmyadmin “c:/wamp64/apps/phpmyadmin5.1.1/”” to “Alias /phpmyadmin “c:/wamp64/apps/phpmyadmin5.2.0/””.
Same goes to this line as well, “Directory “c:/wamp64/apps/phpmyadmin5.1.1/” to “Directory “c:/wamp64/apps/phpmyadmin5.2.0/”.
You may now save and close the file after changing the folder path in the “phpmyadmin.conf” file.

Lastly, you will need to restart your WAMP server. Just right click and hit refresh

wamp server

Now, refresh your phpMyAdmin site or if you’re using WAMP, your phpMyAdmin site should be “http://localhost/phpmyadmin”. Once you login, you should see that you are now using the latest phpMyAdmin version that you just downloaded.

You may delete the old phpMyAdmin folder or keep it just in case you need to roll back to the old version.

You may follow this guide https://www.kintechie.com/how-to-update-php-in-wamp/ if you would like to update your PHP version in WAMP server.

Conclusion

phpMyAdmin is a free and open-source administration tool for managing MySQL databases. With its web-based interface, users can manage MySQL databases, tables, fields, indexes, and relationships from a user-friendly graphical user interface.

Furthermore, phpMyAdmin supports a wide range of operations, including importing and exporting data, creating and editing tables, and executing SQL queries. It is a popular tool for web developers and system administrators who work with MySQL databases.

In conclusion, As a widely-used and versatile tool, understanding the basics of phpMyAdmin can be beneficial for anyone who works with MySQL databases.