blob: 2523e285745deafe40b6cdd694032d842e9cb4bf (
plain)
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'],
}
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}@%"],
}
}
}
|