Resource Type: mysql_user

Defined in:

lib/puppet/type/mysql_user.rb

Providers:

mysql

Overview

@summary Manage a MySQL user. This includes management of users password as well as privileges.

Properties

• ensure (defaults to: present)

  The basic property that the resource should be in.

  Supported values:

  • present
  • absent
• max_connections_per_hour

  Max connections per hour for the user. 0 means no (or global) limit.

  Supported values:

  • %r{\d+}
• max_queries_per_hour

  Max queries per hour for the user. 0 means no (or global) limit.

  Supported values:

  • %r{\d+}
• max_updates_per_hour

  Max updates per hour for the user. 0 means no (or global) limit.

  Supported values:

  • %r{\d+}
• max_user_connections

  Max concurrent connections for the user. 0 means no (or global) limit.

  Supported values:

  • %r{\d+}
• password_hash

  The password hash of the user. Use mysql::password() for creating such a hash.

  Supported values:

  • %r{\w*}
• plugin

  The authentication plugin of the user.

  Supported values:

  • %r{\w+}
• tls_options

  Options to that set the TLS-related REQUIRE attributes for the user.

Parameters

• name (namevar)

  The name of the user. This uses the ‘username@hostname’ or username@hostname.

• provider

  The specific backend to use for this ‘mysql_user` resource. You will seldom need to specify this — Puppet will usually discover the appropriate provider for your platform.