examen1/roles/sample-mysql/tasks/main.yml

- name: ensure partition exists
  parted:
    label: gpt
    device: "{{ partition.device }}"
    number: "{{ partition.number }}"
    part_start: "{{ partition.start }}"
    part_end: "{{ partition.end }}"
    part_type: "{{ partition.type }}"
    state: present
- name: volume group exists
  lvg:
    vg: "{{ volume_group.name }}"
    pvs: "{{ volume_group.partition }}"
    state: present
- name: logical volume exists
  lvol:
    vg: "{{ volume_group.name }}"
    lv: "{{ logical_volume.name }}"
    size: "{{ logical_volume.size }}"
- name: filesystem exists
  filesystem:
    fstype: "{{ filesystem.type }}"
    dev: "/dev/{{ volume_group.name }}/{{ logical_volume.name }}"
#    state: present
- name:
  mount:
    src: "/dev/{{ volume_group.name }}/{{ logical_volume.name }}"
    fstype: "{{ filesystem.type }}"
    path: "{{ filesystem.path }}"
    state: mounted
- name: open firewall for mysql
  firewalld:
    port: 3306/tcp
    state: enabled
    permanent: yes
    immediate: yes
- name: install mysql
  yum:
    name: 
      - mysql-server
      - python3-PyMySQL
    state: latest
- name: start and enable mysql
  service:
    name: mysqld
    state: started
    enabled: yes
- name: Set MySQL root Password
  mysql_user:
    login_host: 'localhost'
    login_user: 'root'
    login_password: ''
    name: 'root'
    password: '{{ mysql.password }}'
    state: present
#- name: change sql root passwd
#  mysql_user:
#    check_implicit_admin: yes
#    login_user: root
#    user: root
#    login_password: "{{ mysql.password }}"