Hi Tom,
I worked around it meanwhile with the following:
- name: Create TinyTinyRSS database user
when: ttr.stat.exists == False
mysql_user: name={{ app_dbUser }}
host=localhost
password="{{ mysql_user_pass.stdout }}"
priv="{{ app_dbName }}.*:SELECT,INS
Hi Dirk
Would you not need to grant SELECT instead of USAGE?
According to MySQL docs, USAGE is granted at the server level. When I
create a user locally (with or without Ansible), that user gets USAGE on
*.* but it doesn't allow them to see any databases.
Regards
Tom
On 11 January 2015 at 07:2
Hello together,
I do have a problem with the mysql_user module.
It does create my user with the provided password, but it does not create
the permissions I do pass.
Here is my call:
- name: Create User with single database privilieges
mysql_user: name="ttr"
host=localhost
