Security Issue

[smiffy47]

I have just installed MySQL on my PC as part of Wamp5, with the idea learning about how to operate a database and intergrate it with my websites. When I open the phpMyAdmin first page there is a warning.
"Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole."
What is this referring to? and how do I "fix the hole"
Thanks.

Life...It's difficult not to take it personally.

http://www.crab.org.uk

http://host-in-the-post.info

http://malawi-youth.org

 

[johnwm]

An initial install of MySQL has no password set for the root user, so anyone logging in as root will have full access to all your databases and admin. The message is advising you to set a root password.

The manual tells all!

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[smiffy47]

Many thanks,
Steve

Life...It's difficult not to take it personally.

http://www.crab.org.uk

http://host-in-the-post.info

http://malawi-youth.org

 

[Kozusnik]

Don't forget...once you change the root password in mySQL, you'll need to change the ./phpMyAdmin/config.inc.php to correspond.

Mark