4 - name: check if MySQL data already exists
8 command: test -d /var/lib/mysql/mysql
11 register: mysql_server_installed
14 - name: setup LVM volume "mysql" for MySQL
23 vg={{ mysql_server_vg }}
24 when: mysql_server_vg != "" and mysql_server_installed.rc != 0
26 - name: create ext4 filesystem on MySQL partition "mysql"
31 dev=/dev/{{ mysql_server_vg }}/mysql
34 when: mysql_server_vg != "" and mysql_server_installed.rc != 0
36 - name: create mount point "/var/lib/mysql"
43 when: mysql_server_vg != "" and mysql_server_installed.rc != 0
45 - name: configure and mount MySQL partition "mysql"
53 src=/dev/{{ mysql_server_vg }}/mysql
55 opts=rw,errors=remount-ro,noatime
57 when: mysql_server_vg != "" and mysql_server_installed.rc != 0
59 - name: install MySQL packages for client and server
73 - name: ensure service "mysql" is enabled and started
83 - name: setup MySQL "ansible" account
89 login_user={{ mysql_server_ansible_user }}
90 login_password={{ mysql_server_ansible_password }}
91 check_implicit_admin=yes
94 password={{ mysql_server_ansible_password }}
98 - name: setup MySQL "root" account
104 login_user={{ mysql_server_ansible_user }}
105 login_password={{ mysql_server_ansible_password }}
106 host="{{ mysql_server_root_host }}"
108 password={{ mysql_server_root_password }}
112 - name: Remove unwanted MySQL "root" accounts (1/2)
118 login_user={{ mysql_server_ansible_user }}
119 login_password={{ mysql_server_ansible_password }}
124 - "{{ ansible_hostname }}"
128 - name: Remove unwanted MySQL "root" accounts (2/2)
134 login_user={{ mysql_server_ansible_user }}
135 login_password={{ mysql_server_ansible_password }}
141 when: mysql_server_root_host != "localhost"