# can the mysql\_user module include additional user requirements?

**URL:** <https://forum.ansible.com/t/can-the-mysql-user-module-include-additional-user-requirements/14645>\
**Category:** Ansible Project\
**Created:** [February 24, 2014, 8:59pm UTC](https://forum.ansible.com/t/can-the-mysql-user-module-include-additional-user-requirements/14645 "2014-02-24T20:59:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brent\_Langston1](https://avatars.discourse-cdn.com/v4/letter/b/c0e974/32.png) [@Brent\_Langston1](https://forum.ansible.com/u/Brent_Langston1)\
**Post date:** [February 24, 2014, 8:59pm UTC](https://forum.ansible.com/t/can-the-mysql-user-module-include-additional-user-requirements/14645/1 "2014-02-24T20:59:21Z")

</div>

I’d like to use the mysql\_user module to create accounts that look like this:

> GRANT ALL PRIVILEGES ON _._ TO ‘bob’@'%’ IDENTIFIED BY ‘pass’ REQUIRE SSL;

Looking at the docs, it’s not immediately obvious how to do this.

```auto
- mysql_user: name=bob host='%' password=pass priv=*.*:ALL state=present

```

```auto
gets close, but doesn't include the "REQUIRE SSL" portion. Is it possible to include "REQUIRE SSL" during account creation?

```

---

<div class="post-metadata">

**Author:** ![Michael\_DeHaan1](https://avatars.discourse-cdn.com/v4/letter/m/5e9695/32.png) [@Michael\_DeHaan1](https://forum.ansible.com/u/Michael_DeHaan1)\
**Post date:** [February 24, 2014, 9:00pm UTC](https://forum.ansible.com/t/can-the-mysql-user-module-include-additional-user-requirements/14645/2 "2014-02-24T21:00:31Z")

</div>

The module will likely require enhancement to take such options.