Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Database Information


When we enter the Databases sub-page, we see the list of existing databases:

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. 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...