Adding database class

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@%"],
+    }
+  }
+}