# Configuring the MySQL database

1. Create databases for the platform and the application.  

E.g.: The following command is used to create the database xxcloudio:

```
create database xxcloudio;
```

   2\. Create a user to access the databases.

E.g.: The following command is used to create a user for the database xxcloudio:

```
create user xxcloudio@localhost IDENTIFIED BY PasswordForUser;
```

{% hint style="info" %}
**Note**

If you want to access this remotely, then replace localhost with '%'
{% endhint %}

 3\. Grant the user privileges required to work with the databases. 

E.g.: The following command is used to grant the user privileges for the database xxcloudio:

```
grant all privileges on xxcloudio.* to xxcloudio_qa@localhost
```

{% hint style="info" %}
**Note**

If you want to give access to all the databases, then replace Database with \*. If you want to give access to all the tables of database, then replace Table with \*.

E.g.: The following command is used to grant the users, the privileges to all the databases and tables.

*"grant all privileges on \*.\* to 'xxcloudio\_qa'@'%"*
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cloudio.io/setting-up-the-cloudio-platform/platform-installation/configuring-the-database/configuring-the-mysql-database.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.