PDA

View Full Version : PHPDev: setting root passwd


ronaldb66
03-25-2004, 03:31 PM
Please forgive any ignorance; I did several searches both in the PHP and MySql forums, but didn't really find an answer to my question. Besides that, I just started horseing around with PHP and MySql anyway.

I recently downloaded and installed PHPDev423, which worked nicely almost straight away; I like using PHPMyAdmin for the time being while experimenting, and learning.
While no password was set for the root user, I didn't manage to connect to MySql from a command window, so I set a password for it through PHPMyAdmin.
This resulted in me getting locked out from PHPMyAdmin since no user called "root" with an empty password could be found anymore. Luckily, this time I could connect to MySql directly to clear the password again.

My question is: how can I modify the PHPMyAdmin settings to not only function with the root user with a password set, but preferably ask me for that password upon entering as well?

If I missed any of the posts that make blatantly clear how to do this, could anyone give me a gentle nudge in the proper direction? I feel kinda lost ... *sob*

firepages
03-25-2004, 05:38 PM
Hi , find the phpmyadmin directory and edit `config.inc.php` , look for this line (near the top) ...

$cfg['Servers'][$i]['auth_type'] = 'config';

change 'config' to 'http' (or 'cookie' though I never tried it ?), you will then need to enter the username and password each time you start a new session.

ronaldb66
04-01-2004, 01:15 PM
Simon,

thanks for the reply; sorry for responding so late, but I've been rather occupied with annoying destractions lately, mainly work... :D I'll give it a try soon.