If we need to find
the database with the most tables, or the database that takes the most space, a simple
click on the Tables or Total column header sorts them accordingly. A second click
reverses the sort order.
Checking the Database Privileges
Clicking the Check Privileges icon displays all the privileges on a specific database.
A user's global privilege might be shown here because it gives him or her access to
this database as well. We can also see the privileges specific to this database. An Edit
link takes us to another page that is used to edit the user's privileges:
MySQL Server Administration
[ 292 ]
Dropping Selected Databases
This is an operation that should not be taken lightly. To drop one or more databases,
we check the boxes next to the names of the databases to be dropped, and click on
the Drop Selected Databases link. A confirmation screen then appears.
Server Operations
The Status, Variables, and Processes links are available to get information about the
MySQL server or to act upon specific processes.
Server Status Verification
These statistics reflect the MySQL server's total activity, including (but not limited to)
the activity generated by queries sent from phpMyAdmin.
The General Status Page
Clicking the Status link produces runtime information about the server. The page
has several sections.
Pages:
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265