Mercurial > repos > other > Puppet
view modules/mysql/examples/monitor.pp @ 389:668df4711671
Update MySQL modules
author | IBBoard <dev@ibboard.co.uk> |
---|---|
date | Mon, 03 Jan 2022 17:16:21 +0000 |
parents | |
children | c6c9a2cfcfbd |
line wrap: on
line source
# @summary # Add a monitoring user to the database $mysql_monitor_password = 'password' $mysql_monitor_username = 'monitoring' $mysql_monitor_hostname = $::facts['networking']['hostname'] mysql_user { "${mysql_monitor_username}@${mysql_monitor_hostname}": ensure => present, password_hash => mysql::password($mysql_monitor_password), require => Class['mysql::server::service'], } mysql_grant { "${mysql_monitor_username}@${mysql_monitor_hostname}/*.*": ensure => present, user => "${mysql_monitor_username}@${mysql_monitor_hostname}", table => '*.*', privileges => ['PROCESS', 'SUPER'], require => Mysql_user["${mysql_monitor_username}@${mysql_monitor_hostname}"], }