O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Deleting databases

We can delete an entire database (including all its tables) using the Drop link in Database view.

Deleting databases

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—You are about to DESTROY a complete database!—appears before a database is deleted.

Note

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required