mysql_user

Collection: community.general

Full Name: parallax.community.general.mysql_user

Aliases: community.general.mysql_user, mysql_user

Synopsis

Manage MySQL and MariaDB user accounts and privileges

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: Grant the application user access to its database
  mysql_user:
    name: app
    password: "{{ mysql_app_password }}"
    host: "10.0.%"
    priv: "appdb.*:ALL"
    state: present