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”

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

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”.

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

How to view the database in PhpMyAdmin (PMA)

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

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”.

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

If you require any further assistance, please create a ticket here.

Created By: Greg K.

Updated on: 22/12/2022