jump to navigation

Enable authentication for phpmyadmin login June 25, 2010

Posted by Tournas Dimitrios in Mysql.
trackback

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.

Solution:

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 🙂

Advertisements

Comments»

1. zajjacEdgar - September 5, 2013

Thanks, was useful.

2. Leo - April 15, 2014

great… thanks, it really helps..

tournasdimitrios1 - April 15, 2014

@Leo
You are welcome 🙂

3. sunil kumar - June 4, 2015

thanks


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