Enable authentication for phpmyadmin login June 25, 2010Posted 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 …
Tthe file — wampdirectory\apps\phpmyadmin188.8.131.52\config.inc–– contains the username and password (on my computer it is C:\Program Files\wamp\apps\phpmyadmin184.108.40.206\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\phpmyadmin220.127.116.11\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 🙂