aboutsummaryrefslogtreecommitdiff
path: root/manifests/database.pp
diff options
context:
space:
mode:
Diffstat (limited to 'manifests/database.pp')
-rw-r--r--manifests/database.pp21
1 files changed, 21 insertions, 0 deletions
diff --git a/manifests/database.pp b/manifests/database.pp
new file mode 100644
index 0000000..c2d1fc3
--- /dev/null
+++ b/manifests/database.pp
@@ -0,0 +1,21 @@
+class database {
+ include mysql::server
+
+ # Database definitions
+ define instance($password) {
+ mysql_database { "$name":
+ ensure => present,
+ }
+
+ mysql_user { "$name@%":
+ password_hash => mysql_password($password),
+ ensure => present,
+ require => Mysql_database["$name"],
+ }
+
+ mysql_grant { "$name@%/$name":
+ privileges => all,
+ require => Mysql_user["$name@%"],
+ }
+ }
+}