Joined December 2013
·
63b99bac5756ed9cb657e7a01196bb2b normal

Chris Houseknecht

Raleigh, NC
·
·
·

I like that you're using Ansible. It puts you on track for making the installation and configuration of mysql a simple, repeatable process. You're off to a good start!

I think there might be a better way to do this though. Firstly, ansible includes several mysql modules, one of which is mysqluser. The mysqluser module will let you modify users, create users, change passwords, etc. This would be preferred over a shell task. Check it out in the documentation here: http://docs.ansible.com/mysql_user_module.html

Secondly, there is a really good role on the Galaxy community site that gives you everything needed for installing, configuring and hardening a mysql host. It's available here: https://galaxy.ansibleworks.com/list#/roles/1

Achievements
47 Karma
560 Total ProTip Views