How to upgrade phpMyAdmin in XAMPP to latest?

Most of the windows users choose XAMMP to install Apache distribution containing MySQL, PHP, phpMyAdmin, and Perl. But, if you try to update any one of the softwares, you may face difficulties. Either you must have to install the latest version of XAMPP (or) you must update the software and configure the web server manually. In such case, we may either loss the data (or) it may remain nonfunctional. So it is safe to take backup of whole files, before trying to install manually.

In this tutorial, I have tried to update the old phpMyAdmin in the XAMPP to phpMyAdmin 4.2.12 (the latest stable release, as on Nov 29, 2014) and faced many technical problems. I searched through google for this issue, but I didn't got a proper solution. Finally, I referred the phpMyAdmin error message and documentations and solved the problem. It works fine now.

The simple and easy steps which I followed is explained below:

  1. Download the latest version of the phpMyAdmin from the official site or directly from the SourceForge server
  2. Uncompress the downloaded compressed file (for example, phpMyAdmin-4.2.12-english.7z).
  3. Rename the uncompressed folder phpMyAdmin-4.2.12-english to phpMyAdmin.
  4. Open the folder and make a copy of the file to in the same folder and do the following changes in
    1. Remove the comment line symbol (//) to enable the feature. If you are not familiar with the lines, simply remove all of the comment line symbols.
    2. Change the username and password in the following lines to your existing phpMyAdmin login details.

      $cfg['Servers'][$i]['controluser'] = 'pma';
      $cfg['Servers'][$i]['controlpass'] = 'pmapass';

  1. Now save and exit the configuration file.
  2. Go to C:\xampp directory and rename the existing folder phpMyAdmin to phpMyAdmin1 (for safety backup).
  3. Move the phpMyAdmin folder (which was modified earlier from phpMyAdmin-4.2.12-english) to the C:\xampp directory.
  4. Open the URL in your browser and enter inside using your login credentials. Ignore the warning messages.
  5. Select the Import tab and load the sql file create_tables.sql from the directory C:\xampp\phpMyAdmin\examples and press Go button.

    phpMyAdmin Import

  1. Select the Databases tab and click the link Check Privileges near the phpmyadmin database.
  2. Click the link Edit Privileges for the pma user. Select all the checkboxes (if you are familiar select only needed checkboxes) and press the Go button. This step is to grant permissions for the pma user account.

    phpMyAdmin Permission

  1. Exit the browser. Clear the temporary files, history, and cookies from the browser. CCleaner software can also be used for this.
  2. Now follow step 8 to open the updated phpMyAdmin page.


Post a Comment

Most Popular Posts

TNEB Bill Calculator

TNEB Bill Calculator (New)

Technical Questions