MySQL privileges - DROP tables, not databases

Question

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

Any ideas?

---

Oh, and the dabase in use is 5.0.45.

Answer 1

I have a same problem :( I think if user can drop all tables then empty database is no value

Answer 2

1. create user
   
2. give drop permissions to the user for said database