xoops forums

ccphui

Just popping in
Posted on: 2006/4/27 5:59
ccphui
ccphui (Show more)
Just popping in
Posts: 7
Since: 2006/4/26
#1

How to set phpmyadmin prompt for login name and password ?

Hi,

I have installed the phpmyadmin and everytime I go to the page,
it will automatically use 'root' user as default login.
I know that this is very unsecure, since everyone can go into
my MySQL thourgh my URL + /phpmyadmin.

So anyone can tell me how to change setting to prompt for
the login name and password everytime the page is being
visited.

Thanks.

Philip Hui.

xuser

Just popping in
Posted on: 2006/4/27 6:55
xuser
xuser (Show more)
Just popping in
Posts: 73
Since: 2002/11/26
#2

Re: How to set phpmyadmin prompt for login name and password ?

set the auth_type to http in you config file of phpmyadmin

ccphui

Just popping in
Posted on: 2006/4/28 1:18
ccphui
ccphui (Show more)
Just popping in
Posts: 7
Since: 2006/4/26
#3

Re: How to set phpmyadmin prompt for login name and password ?

Can you show me the exact me of the config file ?

MySQL version 4.1.15
phpMyAdmin version 2.7.0-pl2

Everytime I click to the page(i.e. http://<myhost>/phpMyAdmin),
it will show up the following without asking for login :-

MySQL version 4.1.15 in localhost, login as root@localhost

xuser

Just popping in
Posted on: 2006/4/28 2:48
xuser
xuser (Show more)
Just popping in
Posts: 73
Since: 2002/11/26
#4

Re: How to set phpmyadmin prompt for login name and password ?

my phpmyadmin version is 2.6.4-pl3

the config file is config.inc.php

and the exact line is :
$cfg['Servers'][$i]['auth_type']     = 'http';      // Authentication method (config, http or cookie based)
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                    // with 'config' auth_type)