Fork me on GitHub
Get XOOPS XOOPSXOOPS FAQFAQ ForumsForums NewsNews ThemesThemes ModulesModules
New Posts New Topics All Posts All Forums Index General Modules Themes Development International XOOPS.org

Search

Donat-O-Meter

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

Learn XOOPS Core

Local Support

Advertisement

XOOPS Code hosted on SourceForge

Cumulus Tag Cloud

- 2 2.5 2.6 4 6 Abuse adslight Android AntiHarvesting AntiSpam API Apple Battlefield billige Blocks Bootstrap Captcha cell chronolabs Clicks content CĂN demo docek download Dresses evden eve facebook Fat floor for free Gateway Google Guide herre Home Honeypot HP html5 Human HỘ IP iPhone jQuery List log Loss module modules Monster new newbb news NHÀ online PARK phone PHP Prevention profile project Protector publisher Rapid RESIDENCE responsive review Rights rmcommon Room security Sentry site Smartphone Smarty Smoking Spam stem Studio support tag tags tdmcreate template The Theme themes User userlog web weight xoops Xortify XPayment ZendFramework

New Users

Registering user

# 137305

bobop

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
Just popping in
Just popping in
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
Just popping in
Just popping in
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
Just popping in
Just popping in
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
Just popping in
Just popping in
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.

[Advanced Search]