Ansible Role MySQL

[](https://travis-ci.org/dgnest/ansible-role-mysql) [](http://waffle.io/dgnest/ansible-role-mysql) [](https://github.com/dgnest/ansible-role-mysql/issues) [](LICENSE)

Installs and configures mysql on a host.

Requirements

• Linux
  • none
• OSX
  • Homebrew must be installed.

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]