Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to upgrade phpMyAdmin in XAMPP to latest?

How to upgrade phpMyAdmin in XAMPP to latest, without affecting the database, settings, and files?

like image 845
ak-SE Avatar asked Nov 25 '14 15:11

ak-SE


People also ask

What is the latest version of phpMyAdmin?

phpMyAdmin 4.9.10 Released 2022-02-11, see release notes for details. Older version compatible with PHP 5.5 to 7.4 and MySQL/MariaDB 5.5 and newer. Currently supported for security fixes only.

How can I change the PHP version used by phpMyAdmin?

Download and Extract phpMyAdmin phpMyAdmin 5.2. 0 (released May 2022) requires PHP 7.2 or newer. To find out your PHP version in command line, run php -v . If you need to upgrade PHP, see guide: How to Upgrade from PHP 7.


2 Answers

This site will be useful for your purpose

https://www.ostraining.com/blog/coding/update-phpmyadmin/

1.) Find Your Version

Navigate to your phpMyAdmin interface and check what version you are using. Notice if it mentions the “latest stable version.”

There will also be a message as you scroll down the page if there is an update to phpMyAdmin.

2.) Find Your phpMyAdmin Directory

Go to your current phpMyAdmin directory.

If you are using XAMPP, on your local computer, typically you install XAMPP to your main hard drive. So open your hard drive, then open the XAMPP folder and you will see your phpMyAdmin directory.

3.) Copy Your Configuration File

Within the phpMyAdmin directory, find config.inc.php and make a copy of it. Place the copy someplace outside of your phpMyAdmin directory, so you can bring it back here in a bit!

4.) Download the Newest Version of phpMyAdmin

Navigate to phpmyadmin.net, download the most recent version of phpMyAdmin. Extract the files.

5.) Put the New Files in Place

Go to your current phpMyAdmin directory, delete all the files in there. Now, go to the new files that you just downloaded and extracted in step 4. Copy all those files, into the phpMyAdmin directory. (The directory where you just deleted everything.) All the new phpMyAdmin files are now in place!

6.) Add Your Config File

Find your config.inc.php file that you made a copy of in step 3.

Copy the file into the phpMyAdmin directory. (It stays in the top level directory.)

You are done! Navigate to your phpMyAdmin interface and utilize the most recent version of phpMyAdmin.

Remember to back up your database in case of potential problems.

Don't forget to restart the mysql/apache servers.

like image 125
Pawel Gumiela Avatar answered Sep 19 '22 22:09

Pawel Gumiela


Also make sure you change the directory path to the current version in the C:\wamp\alias\phpmyadmin.conf file.

Example: first line in file

(old version): Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.1.14/" to
(new version): Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.6.1/".

I Was having a little trouble without this specification.

like image 33
m3ldEr7ake Avatar answered Sep 19 '22 22:09

m3ldEr7ake