🧠 What is MySQL?
MySQL is a popular relational database management system. In the context of a Minecraft server, it can be used for: - Storing player data (e.g., login info, stats, economy systems), - Storing plugin configurations - Synchronizing data across multiple servers (e.g., using BungeeCord or Velocity).
🔐 MySQL Availability
✅ How to Enable MySQL on Your Server
To enable MySQL for your server:
- Go to the dashboard.
- Select your server.
- In the sidebar, click Settings.
- Go to the Basic tab.
- In the MySQL section, set the option to Enabled.
-
Confirm the warning about starting or stopping the server.
🔴 Note: MySQL access will be available once the server has started or stopped.
-
After enabling MySQL, you will see your connection details: host, port, user, password – click the Show button to reveal.
🔗 How to Connect to MySQL
To connect to the MySQL database, you’ll need a client. We recommend the free program HeidiSQL:
👉 Download HeidiSQL
Connection Setup:
- Open HeidiSQL and click New in the bottom-left corner.
- Fill in the fields as follows:
Field | Value from Craftserve Panel |
---|---|
Connection Type | MariaDB or MySQL (TCP/IP) |
Library | (leave default) |
Hostname / IP | Value from the Connection Address |
User | root |
Password | Password shown after clicking “Show” |
Port | Port shown after MySQL is enabled |
- Click Open to connect.
❗ Troubleshooting Connection Issues
🔄 Can't connect to the database
- Go to the dashboard.
- Select your server.
- Navigate to Settings → Basic.
- Check if MySQL is enabled.
-
If the issue persists:
- Make sure all connection credentials are correct.
- Restart the server by holding SHIFT while clicking the Start button – this triggers a deep restart.
- Try connecting again after the restart.
⚙️ Plugin Configuration Details
Use the following credentials in your plugin configuration files:
Parameter | Value |
---|---|
Host | 127.0.0.1 (not localhost ) |
Port | 3306 |
User | root |
Password | Available in the panel |
📄 Plugin Configuration Example:
mysql:
host: 127.0.0.1
port: 3306
user: root
password: your_password
database: example_db