[SOLVED] phpMyAdmin Security

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

phpMyAdmin Security

Post 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)
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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.
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Post by Joe »

Thanks alot bud, much appreciated. :D

Problem solved!
Post Reply