Joined December 2013
·

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
605 Total ProTip Views