- name: Create a new database with name 'wordpress_db'
community.mysql.mysql_db:
name: wordpress_db
state: present
login_unix_socket: /run/mysqld/mysqld.sock
become: yes
- name: Create database user with name 'wordpress_user' and password '12345' with all database privileges
community.mysql.mysql_user:
name: wordpress_user
password: 12345
priv: 'wordpress_db.*:SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER'
state: present
login_unix_socket: /run/mysqld/mysqld.sock
host: "{{ item }}"
with_items:
- 'localhost'
- '127.0.0.1'
- '192.168.1.99'
become: yes
- name: configure database
ansible.builtin.replace:
path: /etc/mysql/mysql.conf.d/mysqld.cnf
regexp: "127.0.0.1"
replace: "0.0.0.0"
become: yes
notify:
- restart mysql