4 - name: check if MySQL data already exists
8 shell: test -d /var/lib/mysql/mysql
10 register: mysql_server_installed
13 - name: setup LVM volume "mysql" for MySQL
22 vg={{ mysql_server_vg }}
23 when: mysql_server_vg != "" and mysql_server_installed.rc != 0
25 - name: create ext4 filesystem on MySQL partition "mysql"
30 dev=/dev/{{ mysql_server_vg }}/mysql
33 when: mysql_server_vg != "" and mysql_server_installed.rc != 0
35 - name: create mount point "/var/lib/mysql"
42 when: mysql_server_vg != "" and mysql_server_installed.rc != 0
44 - name: configure and mount MySQL partition "mysql"
52 src=/dev/{{ mysql_server_vg }}/mysql
54 opts=rw,errors=remount-ro,noatime
56 when: mysql_server_vg != "" and mysql_server_installed.rc != 0
58 - name: install MySQL packages for client and server
71 - name: ensure service "mysql" is enabled and running
80 - name: setup MySQL "ansible" account
85 login_user={{ mysql_server_ansible_user }}
86 login_password={{ mysql_server_ansible_password }}
87 check_implicit_admin=yes
90 password={{ mysql_server_ansible_password }}
94 - name: setup MySQL "root" account
99 login_user={{ mysql_server_ansible_user }}
100 login_password={{ mysql_server_ansible_password }}
101 host="{{ mysql_server_root_host }}"
103 password={{ mysql_server_root_password }}
107 - name: Remove unwanted MySQL "root" accounts (1/2)
112 login_user={{ mysql_server_ansible_user }}
113 login_password={{ mysql_server_ansible_password }}
118 - "{{ ansible_hostname }}"
122 - name: Remove unwanted MySQL "root" accounts (2/2)
127 login_user={{ mysql_server_ansible_user }}
128 login_password={{ mysql_server_ansible_password }}
134 when: mysql_server_root_host != "localhost"