🗄️ How to Create a Database for Your Game Server with Scooperdive 🗄️

Unlock new possibilities for your game server by creating a database! Databases are essential for storing player data, game statistics, and other dynamic information. This guide will walk you through the process of creating a database using the Scooperdive control panel and connecting to it using HeidiSQL, our recommended database management tool.

🎯 Why Do You Need a Database?

• Data Storage: Keep track of player stats, inventories, and other essential data.
• Plugins and Mods: Some game server plugins require a database to function correctly.
• Performance: Offload data processing to a database for smoother server performance.
• Scalability: Easily manage and scale your data as your server grows.

📝 Prerequisites

• An active game server hosted with Scooperdive.
• Access to your Scooperdive control panel.
• HeidiSQL installed on your computer (optional but recommended).

🔧 Step-by-Step Guide to Creating a Database

Step 1: Access the Scooperdive Control Panel

1. Log In: Navigate to panel.scooperdive.com and log in with your credentials.
2. Select Your Server: From the dashboard, click on the server where you want to create a database.

Step 2: Navigate to the Databases Section

1. Find the Databases Tab: In the server panel, locate and click on the "Databases" tab in the sidebar.
2. Create a New Database: Click on the "New Database" button to begin the creation process.

Step 3: Configure Your Database

1. Database Name: Enter a name for your new database. Choose something descriptive to easily identify its purpose.
2. Connection Restrictions (Optional):
   • If you want to restrict which IP addresses can connect to your database, enter them in the "Connections From" field.
   • Leave this field blank if you do not wish to set any restrictions.
3. Create the Database: Click on the "Create" button to generate your database.

Step 4: Retrieve Your Database Details

1. View Database Details: After creation, your new database will appear in the list. Click on "Database Details" to view important information.
2. Take Note of the Following:
   • Database Name
   • Username
   • Password: Automatically generated by the panel. You can randomize it but cannot set a custom password.
   • Host
   • Port

Step 5: Connect to Your Database Using HeidiSQL (Recommended)

Install HeidiSQL

• Download HeidiSQL: Get the latest version from the official website.
• Install: Follow the installation prompts to install HeidiSQL on your computer.

Set Up a New Connection

1. Open HeidiSQL: Launch the application.
2. Create a New Session: Click on "New" to set up a new connection.
3. Configure Connection Settings:
   • Network Type: Select "MySQL (TCP/IP)".
   • Hostname/IP: Enter the Host address from your database details.
   • User: Enter your database Username.
   • Password: Enter your database Password.
   • Port: Use the Port number provided (usually 3306).
4. Save the Session: Give your session a name (e.g., "Scooperdive Server DB") and click "Save".
5. Connect: Click on "Open" to connect to your database.

Secure Your Connection

• Connection Restrictions: If you didn't set any connection restrictions earlier, it's recommended to do so now. Limit connections to your IP address for enhanced security.
  • Go back to the "Databases" section in your Scooperdive panel.
  • Edit your database and add your IP address to the "Connections From" field.

🚀 Utilizing Your Database in Your Game Server

• Configure Plugins/Mods:
  • Input your database details into your server plugins or mods that require database access.
  • Common plugins like EssentialsX, LuckPerms, or Dynmap often need database configurations.
• Test the Connection:
  • Restart your server to ensure the plugins can connect to the database successfully.
  • Check server logs for any connection errors.

🛠️ Troubleshooting Tips

• Cannot Connect via HeidiSQL?

  • Connection Restrictions: Ensure your IP address is allowed in the "Connections From" field.
  • Firewall: Check if your local firewall or antivirus is blocking HeidiSQL.
  • Credentials: Double-check your username and password.

• Plugins Failing to Connect?

  • Incorrect Details: Verify that all database details are correctly entered in your plugin configurations.
  • Plugin Support: Ensure the plugin version is compatible with your server and supports external databases.

• Need to Reset Your Password?

  • In the "Databases" section, select your database and click on "Reset Password". A new password will be generated.
• Still Having Issues?
  • Reach out to our support team at Scooperdive Support. We're here to help!

🤔 Frequently Asked Questions (FAQs)

Q: Can I customize my database password?

A: No, for security reasons, passwords are automatically generated by the panel. You can randomize the password but cannot set a custom one.

Q: Is phpMyAdmin available for database management?

A: No, Scooperdive does not provide phpMyAdmin. We recommend using HeidiSQL for managing your database.

Q: How do I allow my developer access to the database?

A: Add your developer's IP address to the "Connections From" field in the database configuration to grant them access.

Q: What if I need multiple databases?

A: You can create multiple databases by repeating the creation steps. Ensure each database has a unique name.

🎉 Conclusion

Congratulations! You've successfully created a database for your game server. This opens up new opportunities for enhancing your server's functionality and providing a better experience for your players.

Thank you for choosing Scooperdive for your game hosting needs. If you have any questions or need further assistance, don't hesitate to contact our support team through the Scooperdive Control Panel.

Happy gaming!