> 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 %}