Database

--------

The ``database`` role can be used for creating a MariaDB database and

accompanying user on destination machine.

The role implements the following:

* Creates MariaDB database.

* Creates a dedicated user capable of performing any operation on the created

  database. Username is set to be same as the name of database.

Parameters

~~~~~~~~~~

**db_name** (string, mandatory)

  Name of the database that should be created.

**db_password** (string, mandatory)

  Password for the database user.

Examples

~~~~~~~~

Here is an example configuration for creating a single database (for some

website):

.. code-block:: yaml

  - role: database

    db_name: phpinfo_example_com

    db_password: phpinfo_example_com

---

allow_duplicates: yes

---

- name: "Create database {{ db_name }}"

  mysql_db: name="{{ db_name }}" state=present

- name: "Create database user {{ db_name }}"

  mysql_user: name="{{ db_name }}" password="{{ db_password }}"

              priv=*.*:ALL state=present

  - role: database

    db_name: phpinfo_example_com

    db_password: phpinfo_example_com

  - role: database

    db_name: wsgi_example_com

    db_password: wsgi_example_com