Sunday, November 30, 2014

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 http://www.phpmyadmin.net/ or directly from the SourceForge server http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/.
  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 config.sample.inc.php to config.inc.php in the same folder and do the following changes in config.inc.php.
    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 http://127.0.0.1/phpmyadmin/ 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.
  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.
  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.

11 comments :

  1. Remember to back up your database in case of potential problems. Don't forget to restart the mysql/apache servers. Website Design Companies Bangalore

    ReplyDelete
  2. this is great full and helpful you shyer with us Keep updating..
    web design Melbourne | web development Melbourne

    ReplyDelete



  3. Thanks for posting useful information.You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...Really it was an awesome article...very interesting to read..
    please sharing like this information......
    Android training in chennai
    Ios training in chennai

    ReplyDelete
  4. It's interesting that many of the bloggers your tips helped to clarify a few things for me as well as giving.. very specific nice content. And tell people specific ways to live their lives.Sometimes you just have to yell at people and give them a good shake to get your point across.
    Web Design Company
    Web Development Company
    Mobile App Development Company

    ReplyDelete

  5. Nice it seems to be good post... It will get readers engagement on the article since readers engagement plays an vital role in every blog.. i am expecting more updated posts from your hands.
    Android App Development Company

    ReplyDelete
  6. Thanks for sharing this helpful and great information......
    Web Designing Company Delhi

    ReplyDelete
  7. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    web design Company
    web development Company
    web design Company in chennai
    web development Company in chennai
    web design Company in India
    web development Company in India

    ReplyDelete