Database Setup
This guide is the next part after installing the system. If you have not installed the system yet please do so before continuing.
Database Required
The Pterodactyl egg is designed for MySQL (MariaDB) only. If you are using a different database the hosting provider will need to modify your egg.
Creating Database
If your hosting provider allows you to create a database. If not, you will need to either contact your hosting provider or find a database hosting provider.
Redon Tech hosting provides you with a database. You can create a database by following the steps below.
Common Database String Issues
If you use the connection string provided by the panel, you will need to remove the jdbc: from the beginning of the string.
The connection string should look like this mysql://USER:PASSWORD@HOST:PORT/DATABASE.
Connection String
After you have choosen the database type you are going to use, make the connector string and save it for later. You will need it in the next step. Get help with connection strings
Example
mysql://USER:PASSWORD@HOST:PORT/DATABASE
Setting Up ENV Variables
Now that we have our database setup we need to configure the bot to use it. To do this we will use a .env file. This file will contain all of our environment variables that the bot will use. To create the .env file we can do the following.
Replace the values with your own.
Using Prisma
We use Prisma to manage our database. To setup Prisma we will do the following.
- Click the "Startup" tab.
- Enable "DB Push".