28 lines
816 B
YAML
28 lines
816 B
YAML
---
|
|
- name: install tools
|
|
apt: name={{item}} state=present update_cache=yes
|
|
with_items:
|
|
- python3-mysqldb
|
|
- mysql-server
|
|
|
|
- name: install mysql-server
|
|
apt: name=mysql-server state=present update_cache=yes
|
|
|
|
- name: chmod cnf
|
|
copy: src=files/my.cnf dest=/etc/mysql/my.cnf owner=mysql group=mysql mode=0700
|
|
|
|
- name: ensure mysql listening on all ports
|
|
lineinfile: dest=/etc/mysql/my.cnf regexp=^bind-address
|
|
line="bind-address = {{ db_host_ipv4 }}"
|
|
notify: restart mysql
|
|
|
|
- name: ensure mysql started
|
|
service: name=mysql state=started enabled=yes
|
|
|
|
- name: create database
|
|
mysql_db: name={{ db_name }} state=present
|
|
|
|
- name: create user
|
|
mysql_user: name={{ db_user_name }} password={{ db_user_pass }} priv={{ db_name }}.*:ALL
|
|
host='{{ db_user_host }}' state=present
|