Want to add a user to MySQL that you can use for eg backups, monitoring,… or any other tasks this user needs to perform. (in this example a root user)
Create a small definition
1 2 3 4 5 6 |
define create_mysqlbckuser ( $mysqlrootpasswd = '', ) { exec { "create_mysql_bck°user": unless => "/usr/bin/mysqladmin -ubckuser -p'b4ckupP4ss' status", command => "/usr/bin/mysql -uroot -p'$mysqlrootpasswd' -e \"GRANT ALL ON *.* TO 'bckuser'@'%' IDENTIFIED BY 'B4ckupP4ss';flush privileges;\"", } } |
This
From your nodes.pp you can call this by:
1 2 |
create_mysqlbckuser { 'root_user': mysqlrootpasswd => 'B4ckupP4ss, } |
You can always use the Puppetlabs-mysql module of course!
Check here: https://github.com/puppetlabs/puppetlabs-mysql