As a WAMP user, you are familiar with phpMyAdmin. Like any application bundled with WAMP, phpMyAdmin upgrades will be released. How do you know when a new upgrade is released? Simple, phpMyAdmin will tell you in the right sidebar, along with a message across the bottom after you login.

Screenshot of phpMyAdmin with arrow pointing to the upgrade notification message
phpMyAdmin Upgrade Notification

Without further adieu, here’s how to upgrade…

  1. Download the most recent stable version of phpMyAdmin.

  2. Extract the contents of the download to the apps directory inside your WAMP root, typically c:/wamp/apps.

    Screenshot of the most recent stable version of phpMyAdmin being extracted to the apps directory in WAMP
    Extract Upgrade
    • Inside the apps directory is a directory named after the version of phpMyAdmin that is currently running. Leave this directory present in case you need to roll back.
    • After the extraction is finished, I like to rename the extracted directory with the same naming convention that WAMP uses — phpMyAdmin-4.3.6-all-languages becomes phpmyadmin4.3.6.

  3. Copy the config.inc.php configuration file from the current version of phpMyAdmin to the new version.

    Screenshot of the configuration file from the current version of phpMyAdmin being copied to the new version
    Copy phpMyAdmin Configuration

  4. Update the phpmyadmin.conf configuration file located in the alias directory, typically c:/wamp/alias. Point the Alias and <Directory> paths to your new phpMyAdmin directory.

    Screenshot of updated directory paths in the phpmyadmin.conf configuration file
    phpMyAdmin Configuration

  5. Update the wampmanager.conf configuration file located in the WAMP root directory.

    • Toward the bottom of the file, under the [apps] block, change the current phpmyadminVersion setting to your new version number.

      Screenshot of the phpmyadminVersion setting in the wampmanager.conf configuration file
      phpMyAdmin Version

    • Toward the top of the file, under the [main] block, verify that the navigator setting points to the correct location of your computer’s web browser. If this is wrong, you will see the following [perplexing] error message when you try to launch apps from the WAMP menu tray:

      Could not execute menu item (internal error) [Exception] Could not execute run action: The system cannot find the file specified

      Screenshot of the Aestan Tray Menu Error message in WAMP
      WAMP Aestan Tray Menu Error

  6. Last but not least, Restart All Services in WAMP (assuming WAMP is running), and login to your upgraded phpMyAdmin.

    Screenshot of the WAMP menu option to restart all services
    Restart All Services

    Screenshot of phpMyAdmin just after an upgrade was completed
    phpMyAdmin Upgrade Complete
Posted by: John Dugan

Comments

  • niknetniko

    Thanks for the guide!

    For me, the phpmyadmin.conf file was located in the alias directory.

  • Glad to help! …And yes, it is in the alias directory. I’ve updated the post – thx for catching the error 🙂

  • Denes Papp

    thanks, helpful summary!

  • faris rayhan

    thanks for the help

  • Tejas

    Thanks, Helpful summary

  • Thanks for this helpful post…..
    Updated my phpMyAdmin succesfully…. 🙂

  • srinivasreddy

    very very thanks for the help

  • Braday

    After I follow your instruction to update PHPMyadmin, i got this msg “Apache/2.4.9 (Win64) PHP/5.5.12 Server at localhost Port 80” How do give permission to use this port?? Thank you.

  • Viral Champanery

    not working for me . i have follow each and every step but update version is not show in my phpmyadmin and show older version
    please anybody can help me out with this .
    i want to update phpmyadmin from 4.1.14 to 4.5.0.2

  • M.TAYYAB MEHMOOD

    thanks it worked for me.

  • M.TAYYAB MEHMOOD

    Version information: 4.5.0.2 (up to date)

    successfully update

  • Phil Neal

    I had the same problem, but found that if I edit the first line in the c:wampaliasphpmyadmin.conf to match the new version number as well as the directory line as noted above and then Restart All Services it worked

  • Both lines were noted in step 4, and underlined in the corresponding screenshot.

  • Phil Neal

    Thanks, I can see that now. My bad:)

  • PHPmSqL

    Thank you!

  • PHPmSqL

    btw do you know how to add bookmark to phpmyadmin ?

  • Arturo Guillén

    Thanks, man!

  • Nikola Tesla

    updated!_ thanks….

  • After following the steps, restarting the WAMP service and launching PMA I received the dreaded 403 error, access forbidden. It dawned on me that the newly downloaded folder name was phpMyAdmin-4.5.1 is using upper, lower and special characters. If I had read your instructions to the letter I would have used all lower case letters with no spaces or special characters. Once I made the correction in the phpmyadmin.conf directory it all worked PERFECTLY! thanks

  • Happy to help Michael 🙂

  • Marco Yandun

    Hello John. I followed all the steps but the icon remains on orange color. How to know where the problem is and how to fix it? I have WAMP 2.2 installed on a windows 7 x32 machine. Thank you very much…

  • Hi Marco,

    The orange WAMP icon typically indicates issues with Apache. The best way to troubleshoot the issue is to first take a look at your Apache logs. Those can be found in your wamp/log folder, or through the gui. Although, if all you are trying to do is update phpmyadmin, you should retrace the steps above and ensure that you completed each one as noted

  • مدريدي أصيل

    Thanks for your help, it’s very useful

  • CCXVI

    You should then say that it’s actually needed to use the same name format since otherwise it can cause issues! Because you said that you like to rename the folder in a certain way we think that’s nothing but a personal feeling!
    Thanks for the article anyway!

  • thx

  • Great post, quick and easy. I made the same mistake and did not change both sections in “phpmyadmin.config,” a quick glance at the comments and immediately realized what I didn’t do.

    Thanks!

  • Jordi

    Thank you so much John!!

  • Gabi GiuluÈ™an

    Thanks a lot! Worked like a charm [Version information: 4.5.4.1 (up to date)]

  • Stephen Wilson

    Perfect! THANKS for this contribution.

  • Graham Moran

    So I followed all the directions to get this updated and after reading the thread I got it all working. Strangely when I log in to myphpadmin i get the following page. Which give me a a parentdirectory link as well as the newest 4.5.5.1 admin link. Any suggestions on how to not have to go through multiple steps to log in would be greatly appreciated

  • Mohanish

    Worked perfectly !!! Updated WAMP.. Thank you John 🙂

  • Norman Berger

    Thanks – worked perfectly.

  • Chris

    Thank you for your time and hard work putting this article together

  • fallenagus

    Thanks a lot man, I was having db export issues with the phpmyadmin4.5.5.1 version wich comes with WampServer Version 3.0.4 64bit, and used your tut to upgrade to phpMyAdmin4.6.1 and everything is smooth now.

  • luis

    i did everything but when i open on my browser show this message

    Parse error: syntax error, unexpected T_STRING, expecting T_CONSTANT_ENCAPSED_STRING or ‘(‘ in C:wampappsphpmyadmin4.6.0index.php on line 8

  • Mihai_V

    In my wampmanager.conf file, the path to Mozilla Firefox on Windows 7 is written using backslashes, NOT slashes. My latest phpMyAdmin version works OK, but is this how it should be ?

  • Windows uses backslashes. Backslashes are, for the most part, escape characters outside of the Windows world. So, you need to escape the escape character, hence \.

  • Mihai_V

    Thanks ! And, thanks for your VERY HELPFUL tutorial, of course.

  • Thanks for the step-by-step! **Screenshots are always helpful** Easy Peasy.

  • AnnGepp

    Awesome tutorial. Thanks!!

  • James Summers

    Great Instructions, worked perfectly.

  • Pingback: How To Config Phpmyadmin On Wamp | Goods News()

  • Sam

    Thanks, this works just perfectly for me. You re the best

  • You are quite welcome. I’m glad it helped 🙂

  • Malahini

    thanks

  • Ronak

    Thanks man. It worked really well. 🙂

  • Ivan Yosifov

    Great tutorial.
    After restart I got this warning “The secret passphrase in configuration (blowfish_secret) is too short.”. So I opened config.inc.php in new phpmyadmin folder and generated a new value for $cfg[‘blowfish_secret’].

    The other thing is that with the newer version of phpmyadmin you can now enable configuration storage.
    1 Open phpMyAdmin -> Home page
    In the left sidebar check if you have a phpmyadmin database. If you have it, you are set. Otherwise follow the next steps:
    2 Import tab -> File to import -> Browse
    3 select new version of phpMyAdmin -> sql folder (ex. C:wampappsphpMyAdmin4.6.4sql) and select create_tables.sql
    4 create a new user with name [pma] and password [pmapass]. Add privileges.
    5 open config.sample.inc.php from new phpMyAdmin folder and copy this commented out code
    /**
    * phpMyAdmin configuration storage settings.
    */

    /* User used to manipulate with storage */
    // $cfg[‘Servers’][$i][‘controlhost’] = ”;
    // $cfg[‘Servers’][$i][‘controlport’] = ”;
    // $cfg[‘Servers’][$i][‘controluser’] = ‘pma’;
    // $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’;

    /* Storage database and tables */
    // $cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’;
    // $cfg[‘Servers’][$i][‘bookmarktable’] = ‘pma__bookmark’;
    // $cfg[‘Servers’][$i][‘relation’] = ‘pma__relation’;
    // $cfg[‘Servers’][$i][‘table_info’] = ‘pma__table_info’;
    // $cfg[‘Servers’][$i][‘table_coords’] = ‘pma__table_coords’;
    // $cfg[‘Servers’][$i][‘pdf_pages’] = ‘pma__pdf_pages’;
    // $cfg[‘Servers’][$i][‘column_info’] = ‘pma__column_info’;
    // $cfg[‘Servers’][$i][‘history’] = ‘pma__history’;
    // $cfg[‘Servers’][$i][‘table_uiprefs’] = ‘pma__table_uiprefs’;
    // $cfg[‘Servers’][$i][‘tracking’] = ‘pma__tracking’;
    // $cfg[‘Servers’][$i][‘userconfig’] = ‘pma__userconfig’;
    // $cfg[‘Servers’][$i][‘recent’] = ‘pma__recent’;
    // $cfg[‘Servers’][$i][‘favorite’] = ‘pma__favorite’;
    // $cfg[‘Servers’][$i][‘users’] = ‘pma__users’;
    // $cfg[‘Servers’][$i][‘usergroups’] = ‘pma__usergroups’;
    // $cfg[‘Servers’][$i][‘navigationhiding’] = ‘pma__navigationhiding’;
    // $cfg[‘Servers’][$i][‘savedsearches’] = ‘pma__savedsearches’;
    // $cfg[‘Servers’][$i][‘central_columns’] = ‘pma__central_columns’;
    // $cfg[‘Servers’][$i][‘designer_settings’] = ‘pma__designer_settings’;
    // $cfg[‘Servers’][$i][‘export_templates’] = ‘pma__export_templates’;

    6 Paste it in config.inc.php and uncomment
    7 Restart server

  • ZAKARYA ELBAZY

    Thanks man really helped me

  • The1wg

    Thank you very much for such a detailed instructions!

    I followed all of the carefully to be upgraded from phpmyadmin4.1.14 to phpmyadmin4.6.4.

    Now, when I start my localhost WAMP page I can see 2 phpmyadmins there:

    1) – phpmyadmin � ����–
    and
    2) – phpmyadmin (this is old one, it works)

    And when I try to run this phpmyadmin � ����– it returns an error:
    “Not Found
    The requested URL /phpmyadmin � ����–/ was not found on this server.
    Apache/2.4.9 (Win32) PHP/5.5.12 Server at localhost Port 80”

    Please help me to solve the issue.

    Thank you in advance,

    Alex

    https://uploads.disquscdn.com/images/bf58c5c9633428fa6780539df40cff3b6da50a9fe645a206c10b2abad7b550cc.jpg

  • The1wg

    Hi, I just solved this issue.

    The reason of this error was that before making any changes in C:wampaliasphpmyadmin.conf I made a copy of it and left the copy in the same directory.
    That made WAMP to be crazy finding 2 almost similar files. The name of the second phpmyadmin.conf contained some Cyrillic symbols (the word ‘copy” in Ukrainian) that caused so strange name phpmyadmin � ����– to appear.

    I just moved that strange file phpmyadmin � ����– to my Backup folder, closed WAMP and run it again, and everything is now perfect!

    Thank you once more for a good instruction!

    P.S. May be you should mention somewhere in you lesson that users should not leave any copy of any . conf file in the same folder to avoid such an issue?

    BR,
    Alex

  • Jan Oonk

    Thanks alot! This upgrade guide works like a charm! Tested it with WAMPServer 2.5 (64 bit) on Win10 where I upgraded PHPMyAdmin v4.1.14 to PHPMyAdmin v.4.6.3

  • Happy to help 🙂

  • Benjamin Schoofs

    I received
    PHP 5.5+ is required.
    Currently installed version is: 5.3.4

    after restarting all services and opening phpmyadmin

  • Eridson Domingos

    Thank You so much, You helped me. I was find the error: The system cannot find the file specifield when tried to open httpd.conf. I installed notepad++ and I changed the path of notepad to the path of notepad++ during the installation of wamp. Thanks

  • Elle Nandi

    Thank you for this share. Has helped me quite a lot.

  • New Wu

    This is awesome! it works great. Thanks for the sharing!

  • GripperStebson

    Crystal clear instructions. Very helpful. Thanks for publishing them John.

  • JorSofts

    after applying upgrade server display 403 error

  • JorSofts

    ok fixed