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

Learn XOOPS Core

Donat-O-Meter

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

Local Support

Advertisement

XOOPS Code hosted on SourceForge

Cumulus Tag Cloud

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

New Users

Registering user

# 137717

SLNK214324

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]