dev/provisioning/modules/mysql/examples/mysql_user.pp
author ymh <ymh.work@gmail.com>
Fri, 21 Oct 2016 09:26:28 +0200
changeset 379 0b14f178ca53
parent 28 b0b56e0f8c7f
permissions -rw-r--r--
No limitation on the number of item at this level. It has already been checked when preparing the query parameters

$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',
}