# How to create and set up Databases in cPanel?

1. To create databases, access the **MySQL Databases** tool in the **Domains** section.

<figure><img src="https://github.com/sitioshispanos/gitbook-helpdesk-en/blob/master/.gitbook/assets/cPanelDatabases01.png" alt=""><figcaption></figcaption></figure>

2. In the MySQL database administration screen, you will see several areas:
   * **Create database**: where you can create your database. Databases will use the hosting account username as a prefix.
   * **Modify databases**: where you can review and repair any potential errors in your databases.

<figure><img src="https://github.com/sitioshispanos/gitbook-helpdesk-en/blob/master/.gitbook/assets/cPanelDatabases02.png" alt=""><figcaption></figcaption></figure>

* **Current databases**: where you can view and manage the created databases. You can see the space they occupy, modify user privileges, rename, or delete them.
* **MySQL users**: where you can create users that will connect to the databases.

<figure><img src="https://github.com/sitioshispanos/gitbook-helpdesk-en/blob/master/.gitbook/assets/cPanelDatabases03.png" alt=""><figcaption></figcaption></figure>

By clicking on the user privileges in a database, you will see this screen where you can modify their privileges.

<figure><img src="https://github.com/sitioshispanos/gitbook-helpdesk-en/blob/master/.gitbook/assets/cPanelDatabases04.png" alt=""><figcaption></figcaption></figure>

Finally, you will see:

* **Add user to the database**: where you can link users with databases.
* **Current users**: where you can view the created users and modify their data or delete them.

<figure><img src="https://github.com/sitioshispanos/gitbook-helpdesk-en/blob/master/.gitbook/assets/cPanelDatabases05.png" alt=""><figcaption></figcaption></figure>
