Ansible Role: MySQL

This is a modified version of the geerlingguy.mysql role that allows you to choose which MySQL version to install on Debian/Ubuntu systems.

For instructions on using this role, see geerlingguy.mysql.

Requirements

None.

Role Variables

Here are the available variables with their default values. For details on the main variables used in this role, check geerlingguy.mysql role variables.

mysql_version: "5.7"

Settings for installing MySQL:

• mysql_version:string - This indicates the version of MySQL to be installed.

Dependencies

None.

Example Playbook

- hosts: server
  become: yes

  vars:
    mysql_version: "8.0"
    mysql_root_password: super-secure-password
    mysql_databases:
      - name: example_db
        encoding: latin1
        collation: latin1_general_ci
    mysql_users:
      - name: example_user
        host: "%"
        password: similarly-secure-password
        priv: "example_db.*:ALL"

  tasks:
  - import_role:
      name: damianlewis.mysql