Databases Reference
In-Depth Information
server's memory. Modifications to the privileges made from the
User
Overview
page are made both in memory and on disk, in the
mysql
database. Modifications made directly on the
mysql
database do not have
immediate effect. The
Reload
operation reads the privileges from the
database and makes them effective in memory.
The displayed users' list has columns with the following characteristics:
•
•
User
: Users listed in alphabetical order.
Host
: The host for which this user definition applies. This is the machine
name or IP address from which this user will be connecting to the MySQL
server. A
%
value here indicates all hosts.
Password
: Contains
Yes
if a password is defined and
No
if one isn't. The
password itself cannot be seen from phpMyAdmin's interface or by
directly looking at the
mysql.user
table, as it is obfuscated with a one-way
hashing algorithm.
Global privileges
: Listed for each user.
Grant
: Contains
Yes
if the user can grant his or her privileges to others.
•
•
•
Adding a User
The
Add a new user
link brings a dialog for user account creation:
Search WWH ::
Custom Search