> For the complete documentation index, see [llms.txt](https://docs.cloudio.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cloudio.io/setting-up-the-cloudio-platform/platform-installation/configuring-the-database/configuring-the-mysql-database.md).

# 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.