') ') Fork me on GitHub

Search

Donat-O-Meter

Make donations with PayPal!
Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $10.00
Net Balance: $9.41
Left to go: $90.59

Donations
Dante7237  ($10)Dec-3

Learn XOOPS Core

Local Support

Advertisement

XOOPS Code hosted on SourceForge

Cumulus Tag Cloud

- 2 2.5 2.6 3.0 4 6 2013 adslight Android AntiHarvesting AntiMalUser AntiSpam API Apple Battlefield billige Bootstrap By Captcha cell cent chronolabs CHUNG content CĂN demo Digitally docek download Dresses evden eve facebook Fat Food for free Gateway Google Guide herre Honeypot HP Human HỘ IP iPhone jQuery Law Legal List log Loss mobile module modules Monster new newbb news NHÀ online PARK Payment phone PHP Prevention profile project Protector publisher RESIDENCE responsive review Rights rmcommon security Sentry Signatures Signed site Smartphone Solution Spam Studio tdmcreate template The Theme themes tháp web weight Wishcraft xoops Xortify XPayment

New Users

Registering user

# 137911

mydarkglobe

Welcome to XOOPS!




Bottom   Previous Topic   Next Topic  |  Register To Post



#1 Posted on: 2006/4/27 0:59 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.

Top

ccphui
Joined:
2006/4/25 23:01
Group:
Registered Users
Posts: 7
(Show More) (Show Less)


#2 Posted on: 2006/4/27 1:55 Re: How to set phpmyadmin prompt for login name and password ?
set the auth_type to http in you config file of phpmyadmin

Top


Xuser's site
http://xuser.org
http://theme.xoops.org.cn
xuser
Joined:
2002/11/26 7:16
From Beijing / China
Group:
Registered Users
Posts: 73
(Show More) (Show Less)


#3 Posted on: 2006/4/27 20:18 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

Top

ccphui
Joined:
2006/4/25 23:01
Group:
Registered Users
Posts: 7
(Show More) (Show Less)


#4 Posted on: 2006/4/27 21:48 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)


Top


Xuser's site
http://xuser.org
http://theme.xoops.org.cn
xuser
Joined:
2002/11/26 7:16
From Beijing / China
Group:
Registered Users
Posts: 73
(Show More) (Show Less)







You can view topic.
You cannot start a new topic.
You cannot reply to posts.
You cannot edit your posts.
You cannot delete your posts.
You cannot add new polls.
You can vote in polls.
You cannot attach files to posts.
You cannot post without approval.
You cannot use topic type.
You cannot use HTML syntax.
You cannot use signature.
You cannot create pdf.
You cannot get print page.

[Advanced Search]