mysql-play.yml

---
- hosts: DB
  become: yes
  vars_files:
    - mysql-vars.yml

  pre_tasks:
  - name: Install MySQL
    apt: name={{ item }} update_cache=yes cache_valid_time=3600 state=present
    with_items:
    - mysql-server
    - mysql-client
    - python-setuptools
    - python-mysqldb
    - libmysqlclient-dev
    - python3-pip

  - name: Remove a symbolic link
    ansible.builtin.file: 
      path: /usr/bin/python
      state: absent

  - name: Create a symbolic link
    ansible.builtin.file: 
      src: /usr/bin/python3
      dest: /usr/bin/python
      state: link
    register: result
    retries: 3
    delay: 5
    until: result is not failed

  - name: Create a symbolic link
    ansible.builtin.file: 
      src: /usr/bin/pip3
      dest: /usr/bin/pip
      state: link
    register: result
    retries: 3
    delay: 5
    until: result is not failed
      
  - name: Install Python packages
    pip: "name={{ item }} state=present"
    with_items:
      - PyMySQL

  - name: edit firewall
    service:
      name: ufw
      state: stopped
      enabled: false

  tasks:
  - name: Start the MySQL service
    service:
      name: mysql
      state: started
      enabled: true

  - name: Creation mysql file configuration
    file:
      path: "/root/.my.cnf"
      state: touch

  - name: Editing configuration file
    replace:
      path: /etc/mysql/mysql.conf.d/mysqld.cnf
      regexp: '(.*bind-addres.*)'
      replace: '#\1'