aboutsummaryrefslogtreecommitdiffstats
path: root/deploy/adapters/ansible/roles/congress/tasks/congress_db.yml
blob: 16832eaa8a95be2d9be155bee6d9cd9d3710f679 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
##############################################################################
# Copyright (c) 2016 HUAWEI TECHNOLOGIES CO.,LTD and others.
#
# All rights reserved. This program and the accompanying materials
# are made available under the terms of the Apache License, Version 2.0
# which accompanies this distribution, and is available at
# http://www.apache.org/licenses/LICENSE-2.0
##############################################################################
---
- name: create congress db
  mysql_db:
    login_unix_socket: /var/run/mysqld/mysqld.sock
    name: "{{ item.db }}"
    state: present
  with_items: "{{ credentials }}"

- name: create congress db user
  mysql_user:
    login_unix_socket: /var/run/mysqld/mysqld.sock
    name: "{{ item[0].user }}"
    password: "{{ item[0].password }}"
    priv: "*.*:ALL,GRANT"
    host: "{{ item[1] }}"
    state: present
  with_nested:
    - "{{ credentials }}"
    - ['%', 'localhost']