WampServer

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?

Is it documented somewhere?

TonyG

set the password for MySQL first, then restart MySQL for the new password to take effect. then change the password in the phpmyadmin config file.

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

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.

Thank you! I do recall going through those steps once before. It works fine now.

For anyone not used to PHP and MYSQL, setting up can be a pain. But overall WAMP is fantastic compared to setting the server and db up independently!

Hope this may also help others in the future.

Tony