| Coding Tutorials

How to Update phpMyAdmin

phpMyAdmin logo

One of our members asked us how to update their phpMyAdmin version. They were running it under Windows/XAMPP.

You may not be aware that you are running an old version of phpMyAdmin.

In this tutorial, you will learn how to make sure your phpMyAdmin version is current, both for Windows and Linux.

Step #1: Find Your Current Version

  • Navigate to your phpMyAdmin interface and check what version you are using:

Take a look to see what version you are using

On the image above you can see, that my current phpMyAdmin version is 4.7.4 but the latest stable version is 4.8.0. I must update my phpMyAdmin.

Step #2: Find Your phpMyAdmin Folder

  • Go to your current phpMyAdmin folder. If you are using XAMPP on your local computer, typically you install XAMPP to your main hard drive.
  • Open your hard drive.
  • Open your XAMPP folder. You will see your phpMyAdmin folder:

phpmyadmin directory in xampp

Step #3: Rename Your phpMyAdmin Folder

  • Rename your phpMyAdmin folder to phpMyAdmin_old:

rename your phpmyadmin folder

Note: This step is optional. You can update your phpMyAdmin simply by replacing your old phpMyAdmin folder to a newly downloaded one. 

But keeping the old phyMyAdmin folders and files before running the update, just to be on a safe side, is a sound practice. 

This way, if during the update something goes wrong, or you mess things up, you can always rename the folder from phpMyAdmin_old back to phpMyAdmin. And you are back to a working phpMyAdmin version.

Step #4: Copy Your phpMyAdmin Configuration File

  • Within your original phpMyAdmin directory, find the config.inc file:

copy your phpmyadmin configuration file

  • Make a copy of it.  
  • Place the copied file in your new phpMyAdmin directory.

Step #5: Download the Newest Version of phpMyAdmin

  • Navigate to phpmyadmin.net.
  • Download the most recent version of phpMyAdmin.
  • Extract the files onto your hard drive:

05 click extract

  • Copy all the extracted files and folders in your new phpMyAdmin folder.

Step #6: Testing the New Version

  • Now launch your phpMyAdmin. You should see that is has been successfully updated:

phpMyAdmin version is now up to date

Congratulations! You just learned how to update your phpMyAdmin version.

Additional Reading

What's Next

Most major website platforms use MySQL as their default database. phpMyAdmin is a free software, written in PHP, which makes it easy to manage your MySQL databases.

Subscribe to our "How to Use phpMyAdmin to Manage MySQL" video class and learn how to install and use phpMyAdmin. This class will be a huge help to you if you use any PHP-based software.

About the author

Born from Ukrainian mother and Russian father, Alex migrated to the United Kingdom in 1999. He is a self-taught Microsoft Certified Professional. He enjoys learning content management systems and helping web site developers make the most of them.