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

Deleting Databases


We can delete a whole database—including all its tables—using the Drop link in Database view:

By default, $cfg['AllowUserDropDatabase'] is set to FALSE, so this link is hidden to unprivileged users until this setting is manually changed to TRUE.

To help us think twice, a special message appears before a database is deleted: You are about to DESTROY a complete database!

Note

The database mysql containing all user and privilege definitions is so important that the Drop button is deactivated for this database, even for administrators.