4 - name: create LVM LV and file system for MySQL data
11 lvm_vg: "{{ mysql_server_vg }}"
12 lvm_lv_name: "{{ mysql_server_lv_name }}"
13 lvm_lv_size: "{{ mysql_server_lv_size }}"
14 when: mysql_server_vg != ""
16 - name: install MySQL packages for client and server
30 - name: ensure service "mysql" is enabled and started
40 - name: setup MySQL "ansible" account
46 login_user={{ mysql_server_ansible_user }}
47 login_password={{ mysql_server_ansible_password }}
48 check_implicit_admin=yes
51 password={{ mysql_server_ansible_password }}
55 - name: setup MySQL "root" account
61 login_user={{ mysql_server_ansible_user }}
62 login_password={{ mysql_server_ansible_password }}
63 host="{{ mysql_server_root_host }}"
65 password={{ mysql_server_root_password }}
69 - name: Remove unwanted MySQL "root" accounts (1/2)
75 login_user={{ mysql_server_ansible_user }}
76 login_password={{ mysql_server_ansible_password }}
81 - "{{ ansible_hostname }}"
85 - name: Remove unwanted MySQL "root" accounts (2/2)
91 login_user={{ mysql_server_ansible_user }}
92 login_password={{ mysql_server_ansible_password }}
98 when: mysql_server_root_host != "localhost"