# mysql\_user with privs always shows changed

**URL:** <https://forum.ansible.com/t/mysql-user-with-privs-always-shows-changed/14117>\
**Category:** Ansible Project\
**Created:** [December 10, 2013, 8:15pm UTC](https://forum.ansible.com/t/mysql-user-with-privs-always-shows-changed/14117 "2013-12-10T20:15:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yves\_Dorfsman](https://avatars.discourse-cdn.com/v4/letter/y/9de0a6/32.png) [@Yves\_Dorfsman](https://forum.ansible.com/u/Yves_Dorfsman)\
**Post date:** [December 10, 2013, 8:15pm UTC](https://forum.ansible.com/t/mysql-user-with-privs-always-shows-changed/14117/1 "2013-12-10T20:15:22Z")

</div>

Is this a bug (ansible 1.4):

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- name: add user toto  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mysql\_user: name=toto host='%' password='p455w0rd' priv="somedb:ALL"

It works, it does the right thing, but when I run it with the "priv=" that status is always "changed". If I remove the priv, the status is "ok".

---

<div class="post-metadata">

**Author:** ![tannerjc](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/tannerjc/32/985_2.png) [@tannerjc](https://forum.ansible.com/u/tannerjc)\
**Post date:** [December 10, 2013, 8:31pm UTC](https://forum.ansible.com/t/mysql-user-with-privs-always-shows-changed/14117/2 "2013-12-10T20:31:15Z")

</div>

It seems like you are describing a behavior that might be resolved by setting "append" to true:

[https://github.com/ansible/ansible/pull/4352](https://github.com/ansible/ansible/pull/4352)

I can't be sure that's the problem without knowing what exactly "changed".

---

<div class="post-metadata">

**Author:** ![Yves\_Dorfsman](https://avatars.discourse-cdn.com/v4/letter/y/9de0a6/32.png) [@Yves\_Dorfsman](https://forum.ansible.com/u/Yves_Dorfsman)\
**Post date:** [December 10, 2013, 10:09pm UTC](https://forum.ansible.com/t/mysql-user-with-privs-always-shows-changed/14117/3 "2013-12-10T22:09:48Z")

</div>

That's the thing, I'm not chaning anything, I just re-play the same playbook again and again.

---

<div class="post-metadata">

**Author:** ![tannerjc](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/tannerjc/32/985_2.png) [@tannerjc](https://forum.ansible.com/u/tannerjc)\
**Post date:** [December 10, 2013, 10:31pm UTC](https://forum.ansible.com/t/mysql-user-with-privs-always-shows-changed/14117/4 "2013-12-10T22:31:44Z")

</div>

It seems like it's simple to reproduce, so go ahead and file a bug. I assume one of the conditionals is evaluated improperly and changed is always true.

If you want to debug it yourself, that would also speed things up.