jump to navigation

Enable authentication for phpmyadmin login June 25, 2010

Posted by Tournas Dimitrios in Mysql.

Installing the wamp package for a developing enviroment is the most common for webdevelopers.Accepting all the default settings during installation result in a security issue.Anyone can access the database file if they enter “http://addressofwampserver/phpmyadmin” in their browser — no authentication — nothing …

Temporary solution:

Tthe file — wampdirectory\apps\phpmyadmin3.2.0.1\config.inc– contains the username and password (on my computer it is C:\Program Files\wamp\apps\phpmyadmin3.2.0.1\config.inc) As a temporary solution I removed the password form the file, so that nobody, including me, can’t gain access through the browser.

But every time I have to access phpmyadmin, I must first login into my machine with (ssh) and put back the password. This made me look for alternatives.


To make phpmyadmin throw an authentication when being accessed, like this

open the prementioned file (wampdirectory\apps\phpmyadmin3.2.0.1\config.inc) with a text editor ,I personaly prefer notepad++) , and locate the following line of code”””  $cfg[‘Servers’][$i][‘auth_type’] = ‘config’; “””

Now change the line to “”” $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’; “”””

Save the changes and restart your wamp server .Enjoy your web development experiences🙂


1. zajjacEdgar - September 5, 2013

Thanks, was useful.

2. Leo - April 15, 2014

great… thanks, it really helps..

tournasdimitrios1 - April 15, 2014

You are welcome🙂

3. sunil kumar - June 4, 2015


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s