When first installing WAMP, are there some simple steps to go through (in order) to secure the PHPMYADMIN and MYSQL, etc., with passwords, without ending up either locked out of PHPMYADMIN or unable to start the MYSQL service?
I know there is an order to do this in, but I cannot remember which order. Should I secure MYSQL first, then restart, or secure MYPHPADMIN first, then MYSQL?
Thanks for the instructions, but I am still having problems. Must be a dummy.
I opened PHPMYADMIN and set the root@localuser password in the PRIVILEGES section.
I stopped MYSQL and restarted it.
When I open PHPMYADMIN, I get #1045 - Access denied for user 'root'@'localhost' (using password: NO) from MYSQL.
What did I do wrong?
Tony
Re: Simple security steps
Posted by:
mewt
(---.ugr.es)
Date: February 21, 2006 10:02AM
You have to tell phpmyadmin the new password, or tell it to ask for it through the web. Edit the file phpmyadmin/config.inc.php around line 71, set cfg['Servers'][$i]['auth_type'] = 'http'; if you want the phpmyadmin page to ask you for the password every time, or cfg['Servers'][$i]['auth_type'] = 'config'; and then include your root password in $cfg['Servers'][$i]['password'] = 'YOURPASS'; if you want it to be automatically loaded.