Setting up a database is essential for many Minecraft plugins and applications. This guide makes the process simple!

Setup Process

1

Create a server with MariaDB egg

Visit Create server and select the MariaDB egg when creating your server.

2

Start the server

Make sure your server is running before proceeding to the next steps.

3

Create your database

Run the following command in your server console:

CREATE DATABASE dbname;

Replace dbname with a name relevant to your project (e.g., minecraft_economy).

4

Create a database user

Create a user with the following command:

CREATE USER 'dbusername'@'172.18.0.1' IDENTIFIED BY 'password';

Always use a strong, unique password! Weak passwords can compromise your server security.

5

Link the user to the database

Grant the user privileges with:

GRANT ALL ON dbname.* to 'dbusername'@'172.18.0.1' IDENTIFIED BY 'password' WITH GRANT OPTION;

Important Notes

Security

Use a secure password that includes uppercase, lowercase, numbers, and special characters.

Naming

Choose meaningful names for your database and users to keep track of their purpose.

IP Configuration

The default IP (172.18.0.1) is for local connections. Use your node IP if different!

Backups

Regularly backup your database to prevent data loss.

Accessing Your Database

Use these credentials when configuring your applications:

database:
  host: 172.18.0.1  # Enter your node IP if different
  name: dbname      # Your database name
  user: dbusername  # Your database username
  password: password  # Your secure password
  port: 3306        # Default MariaDB port

Need help? Our support team is ready to assist you with any database configuration issues!