mysql_user
Collection: community.general
Full Name: parallax.community.general.mysql_user
Aliases: community.general.mysql_user, mysql_user
Synopsis
Manage mysql user
Parameters
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
| name | string | yes | Name of the MySQL user | |
| password | string | Password for the user | ||
| host | string | localhost | The host part of the MySQL username | |
| state | string | present | State of the user Choices: present, absent | |
| priv | string | MySQL privileges string (e.g. db.*:ALL) | ||
| login_host | string | localhost | Host running MySQL | |
| login_port | int | 3306 | Port of the MySQL server | |
| login_user | string | root | User to authenticate with | |
| login_password | string | Password for authentication | ||
| login_unix_socket | string | Path to a Unix socket for local connections | ||
| encrypted | bool | false | Whether the password is already encrypted | |
| append_privs | bool | false | Append privileges instead of overwriting | |
| check_implicit_admin | bool | false | Check if mysql allows login as root without password | |
| update_password | string | always | When to update the password Choices: always, on_create | |
| plugin | string | Authentication plugin for the user | ||
| plugin_auth_string | string | Authentication string for the plugin | ||
| plugin_hash_string | string | Authentication hash for the plugin | ||
| resource_limits | string | Resource limits for the user (JSON format) | ||
| tls_requires | string | TLS requirements for the user |
Example
- name: Example mysql_user task
mysql_user:
name: <your_name>