36 lines
704 B
YAML
36 lines
704 B
YAML
---
|
|
- name: "Copy .my.cnf file into the root home folder"
|
|
template:
|
|
src: root-my-cnf.j2
|
|
dest: /root/.my.cnf
|
|
owner: root
|
|
group: root
|
|
mode: 0600
|
|
|
|
- name: "Set the root password"
|
|
mysql_user:
|
|
name: root
|
|
host: "{{ item }}"
|
|
password: "{{ mysql_root_password }}"
|
|
check_implicit_admin: yes
|
|
state: present
|
|
with_items:
|
|
- "{{ ansible_hostname }}"
|
|
- "127.0.0.1"
|
|
- "::1"
|
|
- "localhost"
|
|
|
|
- name: "Ensure anonymous users are not in the database"
|
|
mysql_user:
|
|
name: ''
|
|
host: "{{ item }}"
|
|
state: absent
|
|
with_items:
|
|
- "{{ ansible_hostname }}"
|
|
- "localhost"
|
|
|
|
- name: "Remove the test database"
|
|
mysql_db:
|
|
name: test
|
|
state: absent
|