Databases Reference
In-Depth Information
The displayed users' list has columns with the following characteristics:
Column
Characteristic
User
The user account we are defining.
Host
The machine name or IP address, from which this user account
will be connecting to the MySQL server. A
%
value here
indicates all hosts.
Password
Contains
Yes
if a password is defined and
No
if it isn't. The
password itself cannot be seen from phpMyAdmin's interface or
by directly looking at the
mysql.user
table, as it is encrypted
with a one-way hashing algorithm.
Global privileges
A list of the user's global privileges.
Grant
Contains
Yes
if the user can grant his/her privileges to others.
Action
Contains a link to edit this user's privileges or export them.
Exporting privileges
This feature can be useful when we need to create a user with the same password
and privileges on another MySQL server. Clicking on
Export
for user
marc
produces
the following panel:
Search WWH ::
Custom Search