Skip to content

dgnest/ansible-role-mysql

Repository files navigation

Ansible Role MySQL

[![Build Status](https://travis-ci.org/dgnest/ansible-role-mysql.svg)](https://travis-ci.org/dgnest/ansible-role-mysql) [![Stories in Ready](https://badge.waffle.io/dgnest/ansible-role-mysql.svg?label=ready&title=Ready)](http://waffle.io/dgnest/ansible-role-mysql) [![GitHub issues](https://img.shields.io/github/issues/dgnest/ansible-role-mysql.svg)](https://github.com/dgnest/ansible-role-mysql/issues) [![GitHub license](https://img.shields.io/github/license/mashape/apistatus.svg?style=flat-square)](LICENSE)

Installs and configures mysql on a host.

Requirements

  • Linux
    • none
  • OSX

Role Variables

The default role variables in defaults/main.yml are:

---
# defaults file for mysql
mysql_user_home: /root
mysql_root_username: root
mysql_root_password: root
mysql_port: "3306"
mysql_bind_address: '0.0.0.0'
mysql_slow_query_log_enabled: no
mysql_databases:
  - name: example
    collation: utf8_general_ci
    encoding: utf8
mysql_users:
  - name: example
    host: 127.0.0.1
    password: secret
    priv: *.*:USAGE

Dependencies

none

Example Playbook

See the examples directory.

To run this playbook with default settings, create a basic playbook like this:

- hosts: servers
  roles:
     - mysql

To install a specific version:

- hosts: servers
  roles:
     - { role: dgnest.mysql }

Changelog

Please see CHANGELOG for more information what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Credits

Made with ❤️ ️☕️ and 🍕 by dgnest.

  • [Luis Mayta][link-author]