Creating and Managing MySQL Databases

Many advanced Minecraft plugins (like CoreProtect, LuckPerms, Dynmap) require a MySQL database to store data efficiently.

Creating a Database

1. Log in to your Game Panel and open your server.
2. Navigate to the Databases tab.
3. Click the New Database button.
4. Name: Enter a short name for the database (e.g., luckperms or core).
5. Connections (Optional): Enter a percentage or IP to restrict access, or leave as % to allow connections from anywhere (usually required if plugins connect locally).
6. Click Create Database.

Using Your Database

Once created, click the eye icon or look at the database details to find:

• Endpoint: The IP address and port (e.g., 127.0.0.1:3306).
• Username: Your database username.
• Password: Your database password.

Example: Connecting a Plugin

If a plugin's config.yml asks for database details, fill them in like this:

storage-method: mysql
data:
  host: "127.0.0.1"  # The IP from the Endpoint
  port: 3306         # The Port from the Endpoint
  database: "s1_luckperms" # The Full Database Name
  username: "u1_12345"     # Your Database Username
  password: "your_password"

Resetting Passwords

If you forget your database password:

1. Go to the Databases tab.
2. Find the database.
3. Click the Rotate Password button.
4. Copy the new password and update your plugin configurations.