Deploying MySQL on Ubuntu 18.04 with Ansible

This ansible role is to deploy MySQL on Ubuntu 18.04

Requirements

This role requires ansible (indeed), ssh-server and python

Role Variables

Variables required are:

• db_name:
• db_user:
• db_password:

Dependencies

NONE

Example Playbook

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

- hosts: servers
  roles:
     - mysql_db 

login_unix_socket: is very important

          - name: update mysql root password for all root accounts
            mysql_user:
              name: root
              host: "{{ item }}"
              login_unix_socket: /var/run/mysqld/mysqld.sock
              password: "{{ db_password }}"
              login_user: root
              login_password: "{{ db_password }}"
              check_implicit_admin: yes
              priv: "*.*:ALL,GRANT"
            with_items:
              - 127.0.0.1
              - ::1
              - localhost

License

BSD

Author Information

An optional section for the role authors to include contact information, or a website (HTML is not allowed).