Login problem of phpMyAdmin when changing password of 'root'
Posted by: alanX (---.ctinets.com)
Date: June 09, 2006 06:13PM

hi:
I am using wamp 1.6.3. when i change the password of 'root. Then try to login
into phpMyAdmin by typing (http://XXX.XXX.XXX.XX/phpmyadmin/)
It give the message " acess denied.....".

But someone told me, there is a "login in mesasge box" for me to enter the "userid"
& "password", but i can not see it. why ?

Options: ReplyQuote
Re: Login problem of phpMyAdmin when changing password of 'root'
Posted by: roms (---.w193-251.abo.wanadoo.fr)
Date: June 09, 2006 06:18PM

See the phpmyadmin doc, you've got to modifiy your config.inc.php to use the http method for authentication.



Romain

Options: ReplyQuote
Re: Login problem of phpMyAdmin when changing password of 'root'
Posted by: CyberSpatium (67.170.181.---)
Date: June 09, 2006 06:49PM

no, do not change any authentication setting in the phpmyadmin config file. after you change your root users password, you need to restart apache and mysql for the new password settings to take effect. then you need to update the phpmyadmin config file to use your new password.

open config.inc.php file:
C:\wamp\phpmyadmin\config.inc.php

find:
$cfg['Servers'][$i]['password'] = '';

change it to:
$cfg['Servers'][$i]['password'] = 'Your_New_Password_Here';



Post Edited (06-09-06 18:51)

CyberSpatium
----------------------
WAMP Forum Admin

Web Development for Newbie's Blog - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in “geek speak”, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.

Options: ReplyQuote
Re: Login problem of phpMyAdmin when changing password of 'root'
Posted by: alanX (---.ctinets.com)
Date: June 10, 2006 10:54AM

thanks for the answers, but i don't want everyone to login in "phpmyadmin" without enter any passwords. It is not safe enough.

How can i achieve that.

Options: ReplyQuote
Re: Login problem of phpMyAdmin when changing password of 'root'
Posted by: CyberSpatium (67.170.181.---)
Date: June 10, 2006 11:52AM

open up your config.ini.php file again, and find:
$cfg['Servers'][$i]['auth_type'] = 'config';

change to
$cfg['Servers'][$i]['auth_type'] = 'cookie';

Options: ReplyQuote


Sorry, only registered users may post in this forum.