-
Notifications
You must be signed in to change notification settings - Fork 0
/
DBserver_setup.yml
102 lines (86 loc) · 2.83 KB
/
DBserver_setup.yml
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
---
- name: DBServer Setup
hosts: dbserver
become: true
vars:
ansible_python_interpreter: /usr/bin/python3
db_name: "wordpress_db"
db_user: "wordpress_user"
db_user_password: "wordpress_P@ssw0rd"
mysql_collation: utf8mb4_unicode_ci
mysql_encoding: utf8mb4
mysql_bind_address: 0.0.0.0
mysql_max_connections: 200
mysql_root_password: dlgusgh123
tasks:
- name: Ensure pip is installed
yum:
name: python3-pip
state: present
- name: Install MariaDB's package
yum:
name: mariadb-server,python3-pip,python3-PyMySQL
state: present
- name: start mysql server
action: service name=mariadb state=started enabled=true
#한 번만 실행
# - name: Change mariadb root password
# shell: mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED BY 'dlgusgh123';"
- name: update mysql root password
mysql_user:
login_user: root
login_password: dlgusgh123
name: root
host: "192.168.56.*"
password: "{{ db_user_password }}"
check_implicit_admin: yes
priv: "*.*:ALL,GRANT"
- name: setting bind
lineinfile:
path: "/etc/my.cnf.d/mariadb-server.cnf"
insertafter: '#^bind-address=0.0.0.0'
line: "bind-address=0.0.0.0"
state: present
- name: restart db
service:
name: mariadb
state: restarted
# - name: Check if database exists
# shell: "mysql -u root -e 'SHOW DATABASES LIKE \"{{ db_name }}\";'"
# register: db_exists
# ignore_errors: true
# - name: Create Database
# shell: "mysql -u root -e 'CREATE DATABASE {{ db_name }};'"
# when: db_exists.stdout.find(db_name) == -1
# become: true
# become_user: root
# - name: Create DB User and Grant Privileges
# shell: >
# mysql -u root -e "GRANT ALL PRIVILEGES ON {{ db_name }}.* TO '{{ db_user }}'@'192.168.56.*' IDENTIFIED BY '{{ db_user_password }}'; FLUSH PRIVILEGES;"
# become: true
# become_user: root
- name: create a new db
mysql_db:
login_user: root
login_password: "{{ mysql_root_password }}"
login_unix_socket: /var/lib/mysql/mysql.sock
name: "{{ db_name }}"
state: present
- name: delete anonymouse user
mysql_user:
login_user: root
login_password: "{{ mysql_root_password }}"
login_unix_socket: /var/lib/mysql/mysql.sock
name: ""
host_all: yes
state: absent
- name: create a new user
mysql_user:
login_user: root
login_password: "{{ mysql_root_password }}"
login_unix_socket: /var/lib/mysql/mysql.sock
name: "{{ db_user }}"
password: "{{ db_user_password }}"
priv: "*.*:ALL,GRANT"
host: "192.168.56.*"
state: present