manifests/instance.pp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

# Database definitions
define database::instance(
  $password,
  $ensure     = 'present',
  $privileges = "all"
) {
  include mysql::server

  mysql_database { "${name}":
    ensure  => $ensure,
    require => [ Service['mysql'], Exec['set_mysql_rootpw'] ],
  }

  mysql_user { "${name}@%":
    ensure        => $ensure,
    password_hash => mysql_password($password),
    require       => Mysql_database["${name}"],
  }

  if $ensure == 'present' {
    mysql_grant { "${name}@%/${name}":
      privileges => $privileges,
      require    => Mysql_user["${name}@%"],
    }
  }
}