Mysql server Installation

 

Mysql server Installation:

- name: Install Mysql server, Create database with remote login
  become: yes
  hosts: localhost
  vars:
    Mysql_DB: mysqldb
    Mysql_User: mysql_user
    Mysql_Pass: Password
  tasks:
    - name: Mysql Installation
      package:
        name: "{{item}}"
        state: present
        update_cache: yes
      loop:
        - mysql-server
        - mysql-client
        - python3-mysqldb
        - libmysqlclient-dev
      become: yes

    - name: start and enable mysql service
      service:
        name: mysql
        state: started
        enabled: yes

    - name: create  the user
      mysql_user:
        name: "{{ Mysql_User }}"
        password: "{{ Mysql_Pass }}"
        priv: '*.*:ALL'
        host: '%'
        state: present

    - name: creating the database
      mysql_db:
        name: "{{ Mysql_DB }}"
        state: present

    - name: Enable remote login to mysql
      lineinfile:
         path: /etc/mysql/mysql.conf.d/mysqld.cnf
         regexp: '^bind-address'
         line: 'bind-address = 0.0.0.0'
         backup: yes
      notify:
         - Restart mysql
  handlers:
    - name: Restart mysql
      service:
        name: mysql
        state: restarted