WampServer

I finally managed to get PHPMyAdmin working and I now get this 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 by setting a password for user '.root'.


I have looked at the privileges and there are 3 accounts showing:

User Host Password Global privileges Grant
Any % -- USAGE No
root 127.0.0.1 No ALL PRIVILEGES Yes
root localhost No ALL PRIVILEGES Yes

My Question is do you change all the passwords or selected ones, and if you change them all would you use the same password.

Thanks in advance

Anybody know?

[blog.jlbn.net]



Edited 1 time(s). Last edit at 10/05/2011 12:29AM by scarabaeus.

Dude how'd you get your phpmyadmin to work?

@ scarabaeus

I have looked at that blog in the past and it does not make it clear which or all passwords to be changed

there are 3 users showing


Any
root 127.0.0.1
root localhost

also I am a complete novice at this and I find the explanation quite hard to follow a simple step by step is what I neeed.


@pressuredat19

I totally uninstalled every trace of wampserver

used the windows uninstall to remove wampserver

go to C: and uninstall the Wamp Directory

edited the registry to make sure everything to do with wamp was deleted

made sure that wampapache and wampmysql services were not running

Then I reinstalled a slightly older version 2.0i instead of the 2.2a I had been trying to get to work

the older version I got from sourceforge

Hello sherlock,

The link has been corrected.

Of the three entries available for a password you should not enter one for "Any" unless you want 'anybody' who knows the password to have access. This is usually left as is.

root 127.0.0.1
and
root localhost

are the same user "root" and "127.0.0.1" and "localhost" are the same host described with an IP address and a hostname respectively (two ways to reference the same locations).

So...

Any - should be left without a password and with no permissions
root 127.0.0.1 - should be given a password and all privileges granted
root localhost - should be given the same password as 127.0.0.1 and all privileges granted.

The blog post steps through this procedure very explicitly

regards...

Hello Scarabaeus

That seems to have worked

Thank you

Another question if I may

Looking at the server Variables and settings I see the following does it make a difference?

(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci

My language is English