WampServer

in phpmyadmin

Any % Yes USAGE No Edit privileges Edit privileges Export Export
Any localhost Yes USAGE No Edit privileges Edit privileges Export Export
root 127.0.0.1 Yes ALL PRIVILEGES Yes Edit privileges Edit privileges Export Export
root ::1 Yes ALL PRIVILEGES Yes Edit privileges Edit privileges Export Export
root localhost Yes ALL PRIVILEGES

and stil have this
A user account allowing any user from localhost to connect is present. This will prevent other users from connecting if the host part of their account allows a connection from any (%) host

phpMyAdmin gets the users' privileges directly from MySQL's privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.


I reload the privileges


The privileges were reloaded successfully.


when refresh the page

comes back to

A user account allowing any user from localhost to connect is present. This will prevent other users from connecting if the host part of their account allows a connection from any (%) host

phpMyAdmin gets the users' privileges directly from MySQL's privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.

pleasa help



Edited 1 time(s). Last edit at 10/20/2016 03:46PM by Otomatic.

Hi,

A subject is not the place the give all text about the problem !

Explain exactly what your problem is and step by step describe how it occurs.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Oh sorry
the problem these two messages in the user settings in the database


1 top message
A user account allowing any user from localhost to connect is present. This will prevent other users from connecting if the host part of their account allows a connection from any (%) host

2 bottom message
phpMyAdmin gets the users' privileges directly from MySQL's privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.


I mean the safety

set of users that are currently a

Any % Yes USAGE No Edit privileges Edit privileges Export Export
Any localhost Yes USAGE No Edit privileges Edit privileges Export Export
root 127.0.0.1 Yes ALL PRIVILEGES Yes Edit privileges Edit privileges Export Export
root ::1 Yes ALL PRIVILEGES Yes Edit privileges Edit privileges Export Export
root localhost Yes ALL PRIVILEGES

as you can see
I set a password for each user
without changing privileges

I guess what I should do to make them disappear, these messages but humbly ask for help specialists
You
In order to be best protected sever and database from outside

My intuition tells me that in order to improve safety should change

root 127.0.0.1 Yes ALL PRIVILEGES Yes
root ::1 Yes ALL PRIVILEGES Yes

from ALL PRIVILEGES on USAGE
I am not sure?
I do not know what Grant?