I'm more of a PostgreSQL guy lately so I'm probably not the best person to test these, but Mark Theunissen has created some MySQL user and database modules which look pretty awesome to me.
mysql_user and mysql_db are here:
https://github.com/ansible/ansible/tree/devel/library
with examples:
https://github.com/ansible/ansible/blob/devel/examples/playbooks/mysql.yml
As you can see, it can create databases as well as users.
Please test these and report any issues to the list, so we can include this in 0.6
As compared to other MySQL modules, this is written using the API, rather than shelling out to the command line, so the code is a LOT cleaner.
If you do not have the MySQLdb python module, you should install it using the apt or yum modules before executing the MySQL tasks in your playbook.
It will give you a good error message explaining this if you do not have it installed.
We do not think it makes sense to have modules for working with tables -- that should be done by an upgrade script or something inside a package.
Does anyone else have thoughts on other capabilities these should offer?
--Michael