Posted by:
funkyfrank
(---.170.16.17.81.swissinet.com)
OK, I did set a password for some of the root users but somehow I am also at the same time creating new root users that I do not think I need.
Here is a shot of the current users.
[
lh3.googleusercontent.com]
Can you tell me what users I MUST have and what users I can safely delete please?
For example can I delete the "ANY" user?
What is the "%" for Host?
What I think I need is 3 users.
root : localhost : all privs : grant yes
root : 120.0.0.1 : all privs : : grant yes
root : ::1 : all privs : : grant yes
Is this a correct assumption or does WP local dev for example need the "ANY" user?
Hang on, I see "ANY" user with grant no, so that means I have to tell phpMyAdmin that ONLY root user can login where all other users are shut out, correct?
So this means I DO indeed need two "ANY" users, one for host "localhost" with grant no and one for host "%" with grant no. So 5 users total, right?
Thank you.
Best Regards
Frank
Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1
New to WAMP?
Read this please: [
forum.wampserver.com]