Need to create a limited admin user

[col69]

I need to create an admin user with limited rights who can create databases and then grant full rights to these db to another user. If I give the admin user full root privileges (grant all on *.* to 'user'@'localhost' identified by 'pw' with grant option) it works, but I don't want to do this for obvious reasons. What privileges does this admin user need to do just these tasks?

TIA

 

[ericbrunson]

I was just reading

http://dev.mysql.com/doc/mysql/en/GRANT.html

and there doesn't seem to be a specific priv for create database. Take a look at the list of privs on that page and play around with granting them and see if something like create table allows you to create a database.