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:27, Dirk Röder <[email protected]> wrote: > 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 > password=testPass > priv="tinytinyrss.*:USAGE" > state=present > > When I then log into MySQL and view allowed databases: > [root@munin ~]# mysql -u ttr -ptestPass > Enter password: > Welcome to the MariaDB monitor. Commands end with ; or \g. > Your MariaDB connection id is 60 > Server version: 5.5.40-MariaDB MariaDB Server > > Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input > statement. > > MariaDB [(none)]> SHOW DATABASES; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > +--------------------+ > 1 row in set (0.00 sec) > > I tried with different versions of quoting, but none of these helped. The > Database tinytinyrss does exist, was successfully created the ansible task > before. > > My Ansible Version is 1.8.2 > > Regards > Dirk > > -- > You received this message because you are subscribed to the Google Groups > "Ansible Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/d6fe4a7d-fcff-4253-a82e-6f11d43c18d3%40googlegroups.com > <https://groups.google.com/d/msgid/ansible-project/d6fe4a7d-fcff-4253-a82e-6f11d43c18d3%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAAnNz0Mr3dCftSEHiiGCMFjGNYHG6ewwxHi6DD8z6jpw-ZsJAg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
