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_binlog setting
              - mysql_variables: variable=sync_binlog
              
              # Set read_only variable to 1
              - mysql_variables: variable=read_only value=1