Ansible playbook to create a new database

Question

Can someone help me write an ansible task to create database? Thanks in advance.

Answer 1

Hi pravalika, its pretty simple.  You just have to use the mysql_db module if you're using mysql. Mention the name of the database and the state. 

- name: Create a new database with name 'bobdata'
  mysql_db:
    name: mydatabase
    state: present