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.
On the left-hand side, Click “Databases”
![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/db-1_1c0v2we.png)
Click “New Databases” on the top right-hand side corner
![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/btn-1_1em5l0o.png)
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)
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)
Click the hammer icon. This will take you to the PhpMyAdmin page.
![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/hammer-1_1idkw7o.png)
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.
Created By: Greg K.
Let’s find out how to create a MySQL Database on the Apollo panel.
How to create a MySQL Database
On the left-hand side, Click “Databases”
![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/db-1_1c0v2we.png)
Click “New Databases” on the top right-hand side corner
![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/btn-1_1em5l0o.png)
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)
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)
Click the hammer icon. This will take you to the PhpMyAdmin page.
![](https://storage.crisp.chat/users/helpdesk/website/a79efd0b48a91800/hammer-1_1idkw7o.png)
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.
Created By: Greg K.
Updated on: 22/12/2022
Thank you!