Can someone help me with privileges here. I need to create a user that can DROP tables within databases but cannot DROP the databases?
From what I understand from MySQL docs you cannot simply do this:
The DROP privilege enables you to drop (remove) existing databases, tables, and views. Beginning with MySQL 5.1.10, the DROP privilege is also required in order to use the statement ALTER TABLE ... DROP PARTITION on a partitioned table. Beginning with MySQL 5.1.16, the DROP privilege is required for TRUNCATE TABLE (before that, TRUNCATE TABLE requires the DELETE privilege).
Oh, and the dabase in use is 5.0.45.