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|length > 0 and mysql_server_lv_name|length > 0
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 login_unix_socket="/var/run/mysqld/mysqld.sock"
50 check_implicit_admin=yes
53 password={{ mysql_server_ansible_password }}
57 - name: setup MySQL "root" account
63 login_user={{ mysql_server_ansible_user }}
64 login_password={{ mysql_server_ansible_password }}
65 host="{{ mysql_server_root_host }}"
67 password={{ mysql_server_root_password }}
71 - name: Remove unwanted MySQL "root" accounts (1/2)
77 login_user={{ mysql_server_ansible_user }}
78 login_password={{ mysql_server_ansible_password }}
83 - "{{ ansible_hostname }}"
87 - name: Remove unwanted MySQL "root" accounts (2/2)
93 login_user={{ mysql_server_ansible_user }}
94 login_password={{ mysql_server_ansible_password }}
100 when: mysql_server_root_host != "localhost"