# Grant PROXY to MySQL User

**URL:** <https://forum.ansible.com/t/grant-proxy-to-mysql-user/14525>\
**Category:** Ansible Project\
**Created:** [February 7, 2014, 11:31pm UTC](https://forum.ansible.com/t/grant-proxy-to-mysql-user/14525 "2014-02-07T23:31:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrew\_Martin](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Andrew\_Martin](https://forum.ansible.com/u/Andrew_Martin)\
**Post date:** [February 7, 2014, 11:31pm UTC](https://forum.ansible.com/t/grant-proxy-to-mysql-user/14525/1 "2014-02-07T23:31:36Z")

</div>

Hello,

I am working on a playbook to create a new MySQL user and grant it specific privileges. This task works successfully:

- name: Create new database user  
mysql\_user: login\_user={{ mysql\_root\_user }} login\_password={{ mysql\_root\_pass }} name=myuser password={{ user\_password }} priv=_._:ALL,GRANT host=localhost state=present

However, I cannot figure out how to grant the PROXY privilege to the user, what would be the equivalent of this SQL statement:

GRANT PROXY on ‘’@‘’ TO ‘myuser’@‘localhost’ WITH GRANT OPTION;

How can I write a task to grant the PROXY privilege?

Thanks,

Andrew