dev/provisioning/modules/mysql/examples/mysql_user.pp
author ymh <ymh.work@gmail.com>
Fri, 17 Nov 2017 18:02:24 +0100
changeset 568 fd2a9b706231
parent 28 b0b56e0f8c7f
permissions -rw-r--r--
Added tag 0.0.24 for changeset 271e2afbf830

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