Unable to grant privileges using mysql_user module

Archives Ansible Project
1

Hi,

I am trying to create a mysql user ‘webaxnuser’ and grant privileges to it.
Below is the task to do the same.

- name: create use with all priv
mysql_user: login_user=root login_password=pass login_host=188.16.2.3 host=% name=webaxnuser password=Webaxn@123 priv=.:ALL state=present

The user webaxnuser is getting created, however, the priv doesn’t work.
Get the below error:

failed: [188.16.2.3] => {“failed”: true}
msg: (1045, “Access denied for user ‘root’@‘%’ (using password: YES)”)

FATAL: all hosts have already failed – aborting

How do i go about this issue,
Kindly suggest a way forward.

Thanks in advance,
Mona G