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.