title: Ansible doesn't change privilage from USAGE to GRANT ALL
body: <p>I used following ansible task to GRANT ALL privilege to all databases.</p>
  
  <pre><code>- name: create new user {{ db_user }} with all privilege
    mysql_user: name="{{ db_user }}"
                password="{{ db_password }}"
                append_privs=yes
                priv=*.*:ALL,GRANT state=present
  </code></pre>
  
  <p>but when I run <code>show grants for 'dbuser'@'XX.XX.XX.XX';</code> on mysql<code>(mariadb)</code> it shows me following. </p>
  
  <pre><code>GRANT USAGE ON *.* TO 'dbuser'@'XX.XX.XX.XX' IDENTIFIED BY PASSWORD '*A7AD1ECBCD787B8CABE6A58AEA652A8B3CF5035BA82'
  </code></pre>
  
  <p>How to change this USAGE to GRANT ALL using ansible?</p>