1 files changed, 19 insertions, 0 deletions
diff --git a/lamp/tasks/test_dbuser.yml b/lamp/tasks/test_dbuser.yml
new file mode 100644
index 0000000..c2243f3
--- /dev/null
+++ b/lamp/tasks/test_dbuser.yml
@@ -0,0 +1,19 @@
+---
+- name: install dépendances python
+  package:
+    name: '{{ mariadb.pythonlib }}'
+    state: present
+
+- name: Créer la base de données {{ db_user }}
+  community.mysql.mysql_db:
+    name: '{{ db_user }}'
+    state: present
+    login_unix_socket: '{{mariadb.socket}}'
+
+- name: Créer un utilisateur {{ db_user }}
+  community.mysql.mysql_user:
+    name: '{{ db_user }}'
+    password: '{{ db_passwd }}'
+    priv: '{{ db_user }}.*:ALL'
+    state: present
+    login_unix_socket: '{{mariadb.socket}}'