1
ccphui
How to set phpmyadmin prompt for login name and password ?
  • 2006/4/27 5:59

  • ccphui

  • Just popping in

  • Posts: 7

  • Since: 2006/4/26


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.

2
xuser
Re: How to set phpmyadmin prompt for login name and password ?
  • 2006/4/27 6:55

  • xuser

  • Just popping in

  • Posts: 73

  • Since: 2002/11/26


set the auth_type to http in you config file of phpmyadmin
Xuser's site
http://xuser.org
http://theme.xoops.org.cn

3
ccphui
Re: How to set phpmyadmin prompt for login name and password ?
  • 2006/4/28 1:18

  • ccphui

  • Just popping in

  • Posts: 7

  • Since: 2006/4/26


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

4
xuser
Re: How to set phpmyadmin prompt for login name and password ?
  • 2006/4/28 2:48

  • xuser

  • Just popping in

  • Posts: 73

  • Since: 2002/11/26


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)
Xuser's site
http://xuser.org
http://theme.xoops.org.cn

Login

Who's Online

179 user(s) are online (107 user(s) are browsing Support Forums)


Members: 0


Guests: 179


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits