But bill's user definition will still exist in memory, so it is still
effective. If we had chosen the delete the old one from the user tables and reload
the privileges afterwards option instead, bill's user definition would immediately
have ceased to be valid.
Alternatively, we could have created another user based on bill by making use of the
keep the old one choice. We can transfer the password to the new user by choosing
Do not change the password, or change it by entering a new password twice. The
revoke all active privileges option immediately terminates the effective current
privileges for this user if he or she is logged in.
Removing a User
This is done from the User overview section of the Privileges page. We select the
user to be removed, and then (in Removing selected users) we can choose to drop
any databases that have the same name as the users we are deleting. A click on Go
effectively removes the selected users.
Database Information
When we enter the Databases sub-page, we see the list of existing databases:
Chapter 19
[ 291 ]
We also see an Enable Statistics link. By default, statistics are not enabled because
computing the size of data and indexes for all the tables in all the databases may cost
valuable MySQL server resources.
Enabling Statistics
If we click the Enable Statistics link, a modified page appears:
Sorting Statistics
By default, the list is sorted by database name in ascending order.
Pages:
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264