How to Update phpMyAdmin

How to Update phpMyAdmin

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.

Author

  • Alex Smirnov

    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.

0 0 votes
Article Rating
Subscribe
Notify of
62 Comments
Oldest
Newest
Inline Feedbacks
View all comments
SignumSol
10 years ago

Thank you for this post. I used to think doing this was a complicated process. Now my phpMyAdmin is the latest. I use Ampps and the steps worked fine for it.

tiaarvizu
10 years ago

This is fantastic. Thank you so much. I was able to successfully update with no issues. Keep the great tutorials!

Deborah
Deborah
10 years ago

Thanks a lot!!!

I have no technical skills and, moreover, I’m italian: I’ve been able to understand and do the update. Now new version is working correctly. There must be more tutorial like this on the Internet, usually the experts don’t know how to clearly and simply explain things that are difficult to understand for non-technicians.

Grazie.

Melanie H
Melanie H
10 years ago

Glad to hear it has been easy for everyone! I enjoy making things simple for every day users!

germain A
germain A
10 years ago

hello evry one,

I had a problem when upgradind phpmyAdmin. this erreur comes over.

Nouveau concept de sécurité XAMPP:

L’accès au répertoire demandé est uniquement disponible sur le réseau local.

Ce paramètre peut être configuré dans le fichier “httpd-xampp.conf”.

Si vous pensez qu’il s’agit d’une erreur du serveur, veuillez contacter le webmestre.

Error 403

localhost

Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7

Need help to find “httpd-xampp.conf” folder in xampp.

germain A
germain A
10 years ago

Sorry! note that I am French and my Xampp is configure in french. Thanks for all.

Maxelcat
Maxelcat
10 years ago

Thanks for this – seems to have updated as easy as could be… I had posted on the phpmyadmin forum and got no reply.

Steve123
Steve123
10 years ago

Thanks it worked just fine!

Ira
Ira
10 years ago

thx a lot………..it worked !!

justicef
justicef
10 years ago

Hello everyone,
I followed the instructions step by step but the version did not change. Any idea?

thanks

raghav mehra
raghav mehra
10 years ago

after following the above procedure by phpmyadmin shows updated but it shows exclamation marks before databases..i have attached an image to view.

raghav mehra
raghav mehra
10 years ago

the image showing the error.

Apos
Apos
10 years ago

Thanx a lot! Keep up the good work.

🙂

Vimal
Vimal
10 years ago

Thnks…!! a lot

Oki Erie Rinaldi
Oki Erie Rinaldi
10 years ago

I’m using ubuntu, I can’t find the information about the newer version of phpmyadmin. My phpmyadmin version is: 3.5.8.1deb1. Is it a newest version for ilnux?

My Windows PC has phpmyadmin v 4.0.4. Is phpmyadmin for Windows and Linux has different version?

Oki Erie Rinaldi
Oki Erie Rinaldi
10 years ago

I found phpmyadmin package(XAMPP) at [url=http://apachefriends.org]apachefriends.org[/url] that included phpmyadmin 4.0.4. But I’m not using XAMPP on ubuntu, so how can I upgrade the phpmyadmin? I have installed PHP, MySql, and Apache software singly (not packed).

alibagheri
10 years ago

worked for me , thanks 🙂

Slsv
Slsv
10 years ago

Thanks!

steve
steve
10 years ago

Best instructions I’ve seen yet on upgrading to a newer version of phpmyadmin, worked perfectly, thanks so much!!

Jon
Jon
10 years ago

Thank you – brilliant. Worked 1st time & with a Mac too.

nikolaj_sp
nikolaj_sp
10 years ago

Thanks, worked perfectly

Mark
Mark
10 years ago

Works perfectly. Thanks very much!

Warren Bolton
Warren Bolton
9 years ago

Thanks also from me!

Iwansaputra
Iwansaputra
9 years ago

Works great.

Erick Ramírez
Erick Ramírez
9 years ago

Thank you! Gracias!

espi62
9 years ago

There is a message that says: The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
After I click the link it says:
$cfg[‘Servers’][$i][‘users’] …not OK [ Documentation ]

$cfg[‘Servers’][$i][‘usergroups’] …not OK [ Documentation ]

Configurable menus: Disabled
$cfg[‘Servers’][$i][‘navigationhiding’] …not OK [ Documentation ]

Hide/show navigation items: Disabled
$cfg[‘Servers’][$i][‘savedsearches’] …not OK [ Documentation ]

Saving Query-By-Example searches: Disabled
Do i need to enable them and if so, how?
Thank you in advance. JE

steve
steve
7 years ago
Reply to  Jose Espiritu

kindly Login to your phpMyAdmin,

then import create_tables.sql from C:\xampp\phpMyAdmin\sql, if you are a windows plateform

after that logout from phpMyAdmin and Login back

SUCCESS MSG:: Import has been successfully finished, 21 queries executed. (create_tables.sql).

And this alert message will be corrected

steve
steve
7 years ago
Reply to  steve

just follow this steps:
kindly Login to your phpMyAdmin,

then import create_tables.sql from C:\xampp\phpMyAdmin\sql, if you are a windows plateform

after that logout from phpMyAdmin and Login back

SUCCESS MSG:: Import has been successfully finished, 21 queries executed. (create_tables.sql).

And this alert message will be corrected
STEVE:: support@assigndevelopers.com

Fachrian Adi
Fachrian Adi
9 years ago

works like a charm, thank you for sharing 🙂

Jason Robinson
Jason Robinson
9 years ago

Thanks worked fine for me

Neale
Neale
9 years ago

Nice and simple instructions that work although, being a cautious person, I chose to rename the original phpMyAdmin folder to phpMyAdmin.old rather than delete it. The archive file from sourceforge can then be extracted directly into c:\xampp (Ion Windows) as it is provided in a phpMyAdmin folder.

Chirag
Chirag
9 years ago

Thank you for your help. I had been finding the solution for since I got a notification of newer version of phpMyAdmin. Finally I could update it. Thanks again!!!

Pangeran Wiguan
Pangeran Wiguan
9 years ago

It works.

Thanks.

Yogesh Doshi
Yogesh Doshi
9 years ago

Sir is it possible in wampserver to update phpmyadmin??

hadry
hadry
9 years ago

nice and thanks a lot

unc0nnected
unc0nnected
8 years ago

Unfortunately upgrading it seems to break my copy of phpmyadmin. Once upgrade it won’t let me log in to any accounts just saying ‘can’t connect to sql’ and when I downgrade it works perfect.

Oki Erie Rinaldi
Oki Erie Rinaldi
8 years ago
Reply to  unc0nnected

make sure you turned on the mysql service

D'only Brave
D'only Brave
8 years ago

Merci beaucoup!!!

Paulo
Paulo
8 years ago

Perfect! No problems here.

Maryam Aghili
Maryam Aghili
8 years ago

thank you so much, it works for me. btw I have a problem many mysql syntaxes that I found in web do not work on my server and I repeatedly face the error #1064 – You have an error in your SQL syntax; check the manual

that corresponds to your MySQL server version for the right syntax. what is that for? where is my problme?

Wale Naija
Wale Naija
8 years ago

Unable to login after upgrade. Somebody help!

aman
8 years ago

good

Povilas Kapočius
Povilas Kapočius
8 years ago

Thank you very much helped.

fajar setiawan siagian
fajar setiawan siagian
8 years ago

thank you so much

i will try it later

shikha singh
shikha singh
8 years ago

PHP’> WAMP (Windows, Apache, MySQL, PHP) is very simple to establish & you can obtain it from PHP’>WAMP Server abode page.
[url=http://www.phpandsql.com/how-to-use-phpmyadmin-in-xampp/]http://www.phpandsql.com/ho…[/url]

Harish Garg
Harish Garg
7 years ago

my phpmyadmin is not working , but i have installed latest version , please tell me solution .

Fuzzee Lowgeek
Fuzzee Lowgeek
7 years ago

Great post, thanks.

Dario Filosa
Dario Filosa
6 years ago

Thank you!!

2xUeL
2xUeL
6 years ago

Thank you! In my current configuration, I was getting a JavaScript error when I tried to create a particular foreign key. I finally got to the point where I realized I needed to update phpmyadmin and this worked great! Thanks again!

LAurent
LAurent
5 years ago

thank you ! passed the whole day struggling against «NOT EXISTS» queries that suddenly were not working in PhpMyAdmin (??!??) (same query working without «NOT»). I am up to date ! , and queries are working again… thanks to you.

Monica
Monica
5 years ago

Thank you…

Cristian
Cristian
5 years ago

Great, you save my day! Something was broken with the ajax request on my phpMyAdmin. Just …loading… without ending.

Philip
Philip
5 years ago

Thank you very much. Well explained/

ruby
ruby
4 years ago

what if I DO NOT have XAMPP???????????????????????

62
0
Would love your thoughts, please comment.x
()
x