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
72 - name: ensure service "mysql" is enabled and running
82 - name: setup MySQL "ansible" account
88 login_user={{ mysql_server_ansible_user }}
89 login_password={{ mysql_server_ansible_password }}
90 check_implicit_admin=yes
93 password={{ mysql_server_ansible_password }}
97 - name: setup MySQL "root" account
103 login_user={{ mysql_server_ansible_user }}
104 login_password={{ mysql_server_ansible_password }}
105 host="{{ mysql_server_root_host }}"
107 password={{ mysql_server_root_password }}
111 - name: Remove unwanted MySQL "root" accounts (1/2)
117 login_user={{ mysql_server_ansible_user }}
118 login_password={{ mysql_server_ansible_password }}
123 - "{{ ansible_hostname }}"
127 - name: Remove unwanted MySQL "root" accounts (2/2)
133 login_user={{ mysql_server_ansible_user }}
134 login_password={{ mysql_server_ansible_password }}
140 when: mysql_server_root_host != "localhost"