acandid.mysql

MySQL

A simple Ansible role for installing and configuring the MySQL 8 RHEL/CentOS 8.

Install the necessary packages; Create User; Create Database.

Requirements

  • The SELinux and firewall settings are not considered to be a concern of this role.

Role Variables

Variables below are required

Variable Default Comments
mysql_root_user root
mysql_root_pass Inform root password
mysql_db_name Inform new database name
mysql_db_user Inform DB user name
mysql_db_user_pass Inform DB user password
mysql_src_ip Inform DB user src IP address

Dependencies []

Attention

When you run a second time on the same server to just create a new database and a new user, it must be used in the following way below.

ansible-playbook your_playbook.yml --skip-tags "root_pass"

Example Playbook

---
- hosts: dbserver
  become: yes
  roles:
    - mysql
...

Example inventory

[dbserver]

my_server

Contributing

Issues, feature requests, ideas are appreciated and can be posted in the Issues section.

Author Information

LinkedIn: https://br.linkedin.com/in/almircandido

About

Install MySQL 8 on RedHat/CentOS 8 and Create user and database.

Install
ansible-galaxy install acandid.mysql
GitHub repository
License
Unknown
Downloads
293