# Fixing mysql\_user privs using columns - #1120

**URL:** <https://forum.ansible.com/t/fixing-mysql-user-privs-using-columns-1120/18172>\
**Category:** Ansible Developer\
**Created:** [May 6, 2015, 4:42pm UTC](https://forum.ansible.com/t/fixing-mysql-user-privs-using-columns-1120/18172 "2015-05-06T16:42:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bryan\_Fleming](https://avatars.discourse-cdn.com/v4/letter/b/c57346/32.png) [@Bryan\_Fleming](https://forum.ansible.com/u/Bryan_Fleming)\
**Post date:** [May 6, 2015, 4:42pm UTC](https://forum.ansible.com/t/fixing-mysql-user-privs-using-columns-1120/18172/1 "2015-05-06T16:42:50Z")

</div>

Hey all,

Just joined the group, did a search for mysql\_user and didn’t find anything with what I’m trying to fix.

Trying to help out with a bug/feature that would be nice to have when setting permissions which is privs with columns listed. This will help tighten up what that mysql user can use for that DB table if anyone doesn’t want to open up everything for a user.

Github issue here - [https://github.com/ansible/ansible-modules-core/issues/1120](https://github.com/ansible/ansible-modules-core/issues/1120)

The recommended fix for mysql\_user - [https://gist.github.com/bdflemin/902619a453e4ad7e2ecd](https://gist.github.com/bdflemin/902619a453e4ad7e2ecd)

Since this is my first time doing this, wanted some guidance on if I’m approaching this correctly and if any word/code changes to help with getting this issue/feature into ansible-modules-core.

I’m excited to help out with this and possibly more problems down the road.

- Resource links I read
- [http://docs.ansible.com/community.html#i-d-like-to-learn-how-to-develop-on-ansible](http://docs.ansible.com/community.html#i-d-like-to-learn-how-to-develop-on-ansible)
- [https://github.com/ansible/ansible-modules-core/blob/devel/CONTRIBUTING.md](https://github.com/ansible/ansible-modules-core/blob/devel/CONTRIBUTING.md)

Cheers!

---

<div class="post-metadata">

**Author:** ![Bryan\_Fleming](https://avatars.discourse-cdn.com/v4/letter/b/c57346/32.png) [@Bryan\_Fleming](https://forum.ansible.com/u/Bryan_Fleming)\
**Post date:** [May 6, 2015, 9:57pm UTC](https://forum.ansible.com/t/fixing-mysql-user-privs-using-columns-1120/18172/2 "2015-05-06T21:57:44Z")

</div>

After talking it over with one of my colleagues, I went ahead and placed in a PR for the fix/enhancement: [https://github.com/ansible/ansible-modules-core/pull/1272](https://github.com/ansible/ansible-modules-core/pull/1272)

Sorry for the post and hope you all have a good rest of the day.