> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.sparkedhost.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to create a MySQL Database

MySQL databases are sometimes important if you would like to store large amounts of data. It can be much faster than using a JSON file or a sqlite file.

Let’s find out how to create a MySQL Database on the Apollo panel.

### How to create a MySQL Database

1. On the left-hand side, Click “Databases”

![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/db-1_1c0v2we.png)

2. Click “New Databases” on the top right-hand side corner

![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/btn-1_1em5l0o.png)

3. Fill out the required form. The form requires the following:

* Databases name - This is the descriptive name for your database instance
* Connections From - Connections which should be allowed from. Use % for wildcards (Everywhere)
* Database Host - This is where the database instance is going to be deployed.

Once completed, Click “Create Database”.

![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/create-1_jpb8k9.png)

4. Click the eye icon to view the connection details for the database.

![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/eye-1_18wou26.png)

![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/details-1_1x23zeg.png)

### How to view the database in PhpMyAdmin (PMA)

1. Click the hammer icon. This will take you to the PhpMyAdmin page.

![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/hammer-1_1idkw7o.png)

2. Fill out the login form. If you have forgotten the username and/or password, simply head back into the databases tab and click the eye icon. Once the form has been filled out, click “Go”.

![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/pma1-1_3r7mwg.png)

Your databases are now visible on the left-hand side.

![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/pma2-1_1j137mr.png)

---

If you require any further assistance, please create a ticket [here](https://billing.sparkedhost.com/submitticket.php).

---

Created By: Greg K.