Many game server plugins and mods require a MySQL database to store data such as player stats, economy systems, and permissions. Here's how to create and manage databases through the GhostCap Panel.
Creating A Database
- Access the GhostCap Panel and select your server.
- In the sidebar, go to
Management > Databases. - Click
Createand fill in the following:- Host: Select the location closest to your game server.
- Name: A name to identify this database.
- Connections From: Leave this as
%to allow connections from any IP, or enter a specific IP to restrict access.
- Your database credentials (host, port, username, password) will be displayed after creation.
Once created, open the configuration file for your plugin or mod and enter the database details. Refer to the plugin's documentation for the specific field names.
The MySQL port is always 3306.
Deleting a database will permanently remove all data stored in it. Backups do not include databases, and deleted databases cannot be restored.
Resetting Your Database Password
If you need to change your database password:
- Access the GhostCap Panel and select your server.
- In the sidebar, go to
Management > Databases. - Click
Reset Passwordnext to your database.
After resetting, update the password in any plugin or mod configuration files that use this database.
JDBC Connection Strings
Some Java-based plugins (commonly used in Minecraft) require a JDBC connection string. You can find this pre-configured in the database details on the panel. It contains all the information needed to connect, including the host, port, database name, and credentials.