MySQL Users

This roles manages users and databases for a MySQL compatible DB server like MySQL, Galera etc.

Requirements

None.

Role Variables

There are two variables that drive this role: _mysql_users and RW_APT_CACHE_UPDATE. _mysql_users is a map that contains all configuration and settings for this role. RW_APT_CACHE_UPDATE may be specified as an extra variable on invocation of Ansible in order to force apt-get update.

Dependencies

None.

Example Playbook

The general contract of this role is to take the variables map _mysql_users from defaults/main.yml as a template for your configuration and pass that configuration as a parameter to this role.

Including an example of how to use your role (for instance, with variables passed in as parameters) is always nice for users too:

    - hosts: <HOST THAT IS ALLOWED TO MANAGE MYSQL>
      var:
        MYSQL_USERS:
          host: <HOST MYSQL IS RUNNING ON>
          root:
            password: <ADMIN_PASSWORD>
          users:
            grafana:
              state: present
              name: grafana
              password: <DB_USER_PASSWORD>
              privileges: "grafana.*:ALL,GRANT"
              hosts:
                - <HOST ALLOWED TO QUERY>
          databases:
            grafana:
              name: grafana
              state: present
      roles:
         - { role: mysql_users, tags: [ 'mysql_users' ], _mysql_users: "{{ MYSQL_USERS }}" }

License

Please see LICENSE.

Author Information

Original author is Lukas Pustina as member of the Rheinwerk project.