view modules/mysql/examples/mysql_user.pp @ 443:c6c9a2cfcfbd

Update MySQL module Fixes a problem with MariaDB and blank certificate paths
author IBBoard <dev@ibboard.co.uk>
date Mon, 08 May 2023 11:48:41 +0100
parents 668df4711671
children
line wrap: on
line source

$mysql_root_pw = 'password'

class { 'mysql::server':
  root_password => 'password',
}

mysql_user { 'redmine@localhost':
  ensure        => present,
  password_hash => mysql::password('redmine'),
  require       => Class['mysql::server'],
}

mysql_user { 'dan@localhost':
  ensure        => present,
  password_hash => mysql::password('blah'),
}

mysql_user { 'dan@%':
  ensure        => present,
  password_hash => mysql::password('blah'),
}

mysql_user { 'socketplugin@%':
  ensure => present,
  plugin => 'unix_socket',
}

mysql_user { 'socketplugin@%':
  ensure        => present,
  password_hash => mysql::password('blah'),
  plugin        => 'mysql_native_password',
}