Manage mysql databases, users and grants from chef.
- Chef 12.19
- Network accessible package repositories
- Tested on Debian jessie (8), Debian stretch (9), CentOS 7.2 & 7.5
Place a dependency on the mysql cookbook in your cookbook's metadata.rb
depends 'mysql-resources', '~> 0.1.0'
Then in a recipe.
mysql_database 'somedb' do
host 'localhost'
admin_user 'root'
admin_password 'password'
end
mysql_user 'someuser@%' do
host 'localhost'
password 'userpass'
admin_user 'root'
admin_password 'password'
end
mysql_grant 'someuser@%' do
host 'localhost'
right 'all'
on 'somedb.*'
admin_user 'root'
admin_password 'password'
end
Open to contributions on github.