How to create a MySQL database for your server
Databases → New Database → name it → Create Database. Then copy the endpoint, username and password into plugins like LuckPerms or CoreProtect, or into your bot.
- Difficulty:
- Intermediate
- Time:
- 5 minutes
On this page
A database is a safe place for plugins and bots to store data, such as ranks (LuckPerms), block logs (CoreProtect), player money (economy plugins) or your bot's settings. It is faster and more reliable than lots of files, and several servers can share one database, for example every server on a network sharing the same LuckPerms ranks. Game and bot plans include free MySQL (MariaDB) databases that you create yourself in the Databases tab.
How many databases do I get?
Service | Databases |
|---|---|
Minecraft Grass / Plank / Stone | 2 / 3 / 4 |
Minecraft Iron / Gold / Diamond | 5 / 6 / 7 |
Minecraft Netherite / Obsidian / Bedrock plan | 8 / 9 / 10 |
Hytale plans | 3 to 10, depending on the plan |
Bot hosting plans | 1 |
Need MongoDB, PostgreSQL or Redis instead? Those are separate database hosting products. See Connect to your database service.
Create a database
Open your server at panel.endercloud.in, go to the Databases tab and click New Database.
Database name: a short name, for example
luckperms. The panel adds a prefix, so the final name will look a little different.Connection From: leave it blank to allow connections from anywhere (needed if other servers or a desktop tool will connect), or enter one IP address to allow only that address.
Click Create Database.
The new database appears on the Databases page ("Manage databases") with its Name, Username and Endpoint. When you reach your plan's limit, delete a database you no longer use or upgrade your plan.
View your login details
Click the details button (eye icon) next to the database to open Database connection details. You will see:
Endpoint: the host and port, for example
host:3306. Use the host part as the address and the number after the colon as the port.Connections from: who is allowed to connect.
Username and Password.
JDBC Connection String: a ready-made link for Java programs that accept one.
Always copy the database name, username and password exactly as shown, including the prefix.
Example: LuckPerms
In plugins/LuckPerms/config.yml, set the storage method and fill in the data section with your own values:
storage-method: mysql
data:
address: YOUR-HOST:3306
database: YOUR-DATABASE-NAME
username: YOUR-USERNAME
password: 'YOUR-PASSWORD'Save the file and restart the server. More in LuckPerms ranks and permissions.
Example: CoreProtect
In plugins/CoreProtect/config.yml:
use-mysql: true
mysql-host: YOUR-HOST
mysql-port: 3306
mysql-database: YOUR-DATABASE-NAME
mysql-username: YOUR-USERNAME
mysql-password: YOUR-PASSWORDUse the host and port from your Endpoint, not localhost or 127.0.0.1. Then restart and check the console for a successful database connection.
Rotate the password
If a password has been shared or leaked, open the database details and click Rotate Password. A new password is created straight away. Update it in every plugin or bot config that uses this database and restart, or they will stop connecting.
Frequently asked questions
Can two servers share one database?
Yes, if Connection From allows both. This is how networks share LuckPerms data between a proxy and several servers: use the same login details in each server's config.
"Access denied for user" error
The username or password is wrong, or your IP is not allowed in Connection From. Copy the details again (with the prefix) and check for spaces at the start or end.
Can I use a desktop tool like HeidiSQL or DBeaver?
Yes, as long as Connection From allows your IP (or is %). Use the endpoint, username and password from the panel.
Was this article helpful?
Related articles
USA (Virginia) VPS are managed inside the billing panel from the Servers page, with Overview, Network, Access, Snapshots, Activity and Settings tabs. ARM plans can't run x86-only software.
A walk through the Endercloud Game Panel: the home page, server folders, Ctrl+K search and what every sidebar tab (Dashboard to Startup) is for.
Open the Network tab and click Create Allocation to get an extra port for Geyser, voice chat, web maps or a bot's web server. The allocation count includes your main port.
At panel.endercloud.in/account you can change your panel email, username and theme, set a password and 2FA, add SSH keys for SFTP, create API keys and check your account activity.
