Dec 13, 2013

f Comment

How Do You Upgrade PhpMyAdmin in WAMP in SECONDS?

Amazon WAMP is a great tool for running Apache, MySQL, PHP on Windows. WAMP also includes PhpMyAdmin. If you want to change the version of PhpMyAdmin, follow these steps.

Let's assume your WAMP is installed at C:\wamp2.5\.

Step 1

Download the desired version of the PhpMyAdmin software at http://www.phpmyadmin.net/downloads/. For example, I'd like to download PhpMyAdmin version 4.4.10. So I click on phpMyAdmin-4.4.10-english.zip.

Step 2

Once I've downloaded the package, decompress it to get the folder phpMyAdmin-4.4.10-english/. Copy the entire folder to C:\wamp2.5\apps.

Step 3

Edit PhpMyAdmin's alias file at C:\wamp2.5\alias\phpmyadmin.conf to the following.
#Alias /phpmyadmin "c:/wamp2.5/apps/phpmyadmin4.1.14/"
Alias /phpmyadmin "c:/wamp2.5/apps/phpMyAdmin-4.4.10-english/"

# to give access to phpmyadmin from outside 
# replace the lines
#
# Require local
#
# by
#
# Require all granted
#

#<Directory "c:/wamp2.5/apps/phpmyadmin4.1.14/">
<Directory "c:/wamp2.5/apps/phpMyAdmin-4.4.10-english/">
   Options Indexes FollowSymLinks MultiViews
   AllowOverride all
  <IfDefine APACHE24>
    Require local
  </IfDefine>
  <IfDefine !APACHE24>
    Order Deny,Allow
   Deny from all
   Allow from localhost ::1 127.0.0.1
 </IfDefine>
  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360
</Directory>
As you can see I commented out the old lines in the alias file.

Step 4

Go to C:\wamp2.5\apps\phpMyAdmin-4.4.10-english\ and make a copy of config.sample.inc.php and name it config.inc.php. Add the following lines to config.inc.php:
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'myRootPassword';
You may need to comment out the following line in config.inc.php:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
Restart WAMP and you are done!

Questions? Let me know!
Please leave a comment here!
One Minute Information - by Michael Wen
ADVERTISING WITH US - Direct your advertising requests to Michael