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 ansible-project+unsubscr...@googlegroups.com. To post to this group, send email to ansible-project@googlegroups.com. 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.