upgrade to the new version of PhpMyAdmin 3.3.4

Since 28th of June, the new version of phpMyAdmin 3.3.4 came out and here is how you can upgrade your previously installed version to the newer one.
My setup is on Windows with Wamp so if you have another local host running, you’ll have to adapt to your way of working, but I’ll bet that the difference isn’t that big.

My start screen looked something like this, on which we can see the older version and obviously it’s time to upgrade.

Go to the download page and download the latest version you prefer. As my whole environment is set in English I just select the phpMyAdmin-3.3.4-english.7z version.

Second step is to extract the downloaded files to your local location and set the rights as you prefer. This can be done in different ways but I prefer the manual way, this is done by copying the config.sample.inc.php, renaming it to config.inc.php and change the preferences in the file as you prefer.

In my case the only two lines that had to be changed where:

$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'blabla';

If you need more information, it can be found in the documentation included in the package (documentation.txt).

If we go to the location on our local host now (in my case http://localhost/phpMyAdmin/) we get an error saying that we don’t have permissions to view this page.

In order to get this working we need to set the phpmyadmin.conf file and adapt it, the alias and directory need to be adapted to the freshly installed version.

Alias /phpmyadmin "C:\wamp\apps\phpMyAdmin-3.3.4-english"

# to give access to phpmyadmin from outside
# replace the lines
#
#        Order Deny,Allow
#	Deny from all
#	Allow from 127.0.0.1
#
# by
#
#        Order Allow,Deny
#   Allow from all
#

<Directory "C:\wamp\apps\phpMyAdmin-3.3.4-english/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
	Deny from all
	Allow from 127.0.0.1
</Directory>

After restarting your local wamp, you’ll get the correct and new version of phpMyAdmin in your browser.

Have fun.