# I've pushed Mark's MySQL modules to the devel branch, please help test

**URL:** <https://forum.ansible.com/t/ive-pushed-marks-mysql-modules-to-the-devel-branch-please-help-test/11679>\
**Category:** Ansible Project\
**Created:** [July 14, 2012, 3:22pm UTC](https://forum.ansible.com/t/ive-pushed-marks-mysql-modules-to-the-devel-branch-please-help-test/11679 "2012-07-14T15:22:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_DeHaan](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@Michael\_DeHaan](https://forum.ansible.com/u/Michael_DeHaan)\
**Post date:** [July 14, 2012, 3:22pm UTC](https://forum.ansible.com/t/ive-pushed-marks-mysql-modules-to-the-devel-branch-please-help-test/11679/1 "2012-07-14T15:22:38Z")

</div>

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](https://github.com/ansible/ansible/tree/devel/library)

with examples:

[https://github.com/ansible/ansible/blob/devel/examples/playbooks/mysql.yml](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

---

<div class="post-metadata">

**Author:** ![Mark\_Theunissen](https://avatars.discourse-cdn.com/v4/letter/m/898d66/32.png) [@Mark\_Theunissen](https://forum.ansible.com/u/Mark_Theunissen)\
**Post date:** [July 14, 2012, 4:46pm UTC](https://forum.ansible.com/t/ive-pushed-marks-mysql-modules-to-the-devel-branch-please-help-test/11679/2 "2012-07-14T16:46:00Z")

</div>

Thanks Michael, I’m happy to maintain and do bugfixes/feature requests on this if/when they crop up.

- Mark