mysql_variables - Manage MySQL global variables

Synopsis

New in version 1.3.

Query / Set MySQL variables

Options

parameter	required	default	choices	comments
login_host	no			mysql host to connect
login_password	no			password to connect mysql host, if defined login_user also needed.
login_unix_socket	no			unix socket to connect mysql server
login_user	no			username to connect mysql host, if defined login_password also needed.
value	no			If set, then sets variable value to this
variable	yes			Variable name to operate

Examples

# Check for sync_binary_log setting
- mysql_variables: variable=sync_binary_log

# Set read_only variable to 1
- mysql_variables: variable=read_only value=1