Can you please cross check this
Im trying to create a user but it gets executed but the user is not getting
created in my RDS mysql DB .
--------------------
---
#creating a sql user
- hosts: localhost
tasks:
#- name: test
- mysql_user: login_host=abcde.us-west-2.rds.amazonaws.com
priv=*.*:SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,RELOAD,PROCESS,REFERENCES,INDEX,ALTER,SHOWDATABASES,CREATETEMPORARYTABLES,LOCKTABLES,EXECUTE,REPLICATIONSLAVE,REPLICATIONCLIENT,CREATEVIEW,SHOWVIEW,CREATEROUTINE,ALTERROUTINE,CREATEUSER,EVENT
login_port=3306 login_user=klm login_password=abc name=marley password=klms
state=absent
On Friday, July 12, 2013 9:36:08 PM UTC+5:30, Dmitry Makovey wrote:
>
> Hi,
>
> my current usecase is to walk around multiple MySQL DB hosts and remove
> user from them. Sounds like a nice usecase for mysql_user module. Bit of
> complication: all hosts have different root credentials. I do not want to
> either hardcode credentials into the playbook/CLI invocation nor do I feel
> comfortable sticking it on every box under ${HOME}/.my.cnf . What are
> current recommendations for this kind of scenario. I've seen vars_prompt,
> however since I'll need it per-host: how do I do that? Another thing -
> since we're talking "action" vs "configuration" I felt it's a task for
> "ansible CLI" vs "ansible-playbook", am I understanding things correctly?
> What shall I do with multiple hosts and their login credentials?
>
--
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/377505c9-ad1c-49a6-b5ef-e8b5dac8f324%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
