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 lvm_lv_mountpoint: "/var/lib/mysql"
15 when: mysql_server_vg != "" and mysql_server_lv_name != ""
17 - name: install MySQL packages for client and server
31 - name: ensure service "mysql" is enabled and started
41 - name: setup MySQL "ansible" account
47 login_user={{ mysql_server_ansible_user }}
48 login_password={{ mysql_server_ansible_password }}
49 check_implicit_admin=yes
52 password={{ mysql_server_ansible_password }}
56 - name: setup MySQL "root" account
62 login_user={{ mysql_server_ansible_user }}
63 login_password={{ mysql_server_ansible_password }}
64 host="{{ mysql_server_root_host }}"
66 password={{ mysql_server_root_password }}
70 - name: Remove unwanted MySQL "root" accounts (1/2)
76 login_user={{ mysql_server_ansible_user }}
77 login_password={{ mysql_server_ansible_password }}
82 - "{{ ansible_hostname }}"
86 - name: Remove unwanted MySQL "root" accounts (2/2)
92 login_user={{ mysql_server_ansible_user }}
93 login_password={{ mysql_server_ansible_password }}
99 when: mysql_server_root_host != "localhost"