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:
???
??? ???
???
??? ???
MySQL Server Administration
[ 284 ]
User Name
The User name menu offers two choices. We can choose Use text field and input a
user name in the box, or we can choose Any user to create an anonymous user (the
blank user). Let's choose Use text field and enter bill.
Host
By default, this menu is set to Any host with % as the host value. The Local choice
means "localhost". The Use host table choice (which creates a blank value in the
host field) means to "look in the mysql.
Pages:
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259