Page 1 of 1

phpMyAdmin Security

Posted: Mon Aug 23, 2004 9:59 am
by Joe
I have updated my version of phpMyAdmin but I have bumped into a small problem. I am unable to password protect it. This means that anyone can view my tables.

This is my first time installing phpMyAdmin as it was automatically installed the last time. Can anyone please help me here, I have tried searching the web up and down with no luck.

Thanks


Joe 8)

Posted: Mon Aug 23, 2004 10:09 am
by markl999
Just edit config.inc.php and check the lines around:
$cfg['Servers'][$i]['auth_type'] where the auth method is specified. Eg:
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = 'root'; //or use a non root mysql user
$cfg['Servers'][$i]['password'] = '';

That will 'pop up' a login box where you'll need to enter the user/password.

Posted: Mon Aug 23, 2004 10:20 am
by Joe
Thanks alot bud, much appreciated. :D

Problem solved!