Grant PROXY to MySQL User

Archives Ansible Project
1

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