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 🙂
Thanks, was useful.
great… thanks, it really helps..
@Leo
You are welcome 🙂
thanks