32 lines
856 B
YAML
32 lines
856 B
YAML
- name: Installation de MySQL
|
|
ansible.builtin.apt:
|
|
name:
|
|
- "mysql-server"
|
|
- "python3-pymysql"
|
|
notify:
|
|
- "Restart MySQL"
|
|
|
|
- name: Set MySQL bind_address parameter
|
|
ansible.builtin.lineinfile:
|
|
path: "/etc/mysql/mysql.conf.d/mysqld.cnf"
|
|
regexp: "^bind-address\\s+="
|
|
line: "bind-address = *"
|
|
notify:
|
|
- "Restart MySQL"
|
|
|
|
- name: Création des bases de données MySQL
|
|
loop: "{{ mysql_databases }}"
|
|
community.mysql.mysql_db:
|
|
login_unix_socket: "/var/run/mysqld/mysqld.sock"
|
|
name: "{{ item }}"
|
|
encoding: "utf8"
|
|
|
|
- name: Création des utilisateur MySQL
|
|
loop: "{{ mysql_users }}"
|
|
community.mysql.mysql_user:
|
|
login_unix_socket: "/var/run/mysqld/mysqld.sock"
|
|
name: "{{ item.name }}"
|
|
password: "{{ item.password }}"
|
|
priv: "{{ item.priv }}"
|
|
host: "{{ item.host | default('127.0.0.1') }}"
|