Ansible role: Terraform

This role helps you to install mariadb on your linux machine.

Travis	GitHubActions	Quality	Downloads	Version

Requirements

• Linux machine
• Ansible 2.10

Role Variables

These variables help you to manage mariadb installation.

You can specify your mariadb root password in this variable.

mariadb_root_password: changemeplease

By setting the root password you can create users using mariadb_users list. Here you add users with privilleges to databases or tables.

mariadb_users:
  - name: john
    password: doe
    host: localhost
    priv: "mydatabase.*:ALL"
    state: present

  - name: jess
    password: doe
    host: localhost
    priv: "*.*:ALL"
    state: present

After settings the users you can create the databases with the appropriate users.

mariadb_databases:
  - name: mydatabase
    login_user: john
    login_password: doe
    state: present

  - name: mydatabase
    login_user: jess
    login_password: doet
    state: present

Example Playbook

- hosts: all
  vars:
    mariadb_users:
      - name: john
        password: doe
        host: localhost
        priv: "mydatabase.*:ALL"
        state: present

    mariadb_databases:
      - name: mydatabase
        login_user: john
        login_password: doe
        state: present
  roles:
     - amine7777.mariadb

Author Information

• Amine Kahlaoui, DevOps engineer.