Adding MySQL Databases
This guide will help you add MySQL databases to your server
Hey there MinecraftGamers! πŸ‘‹
In this guide, we will go over how to create MySQL databases for your Minecraft server.
First, go to your game panel and on the left sidebar, select 'Databases'.
Could not load image
dedicatedminecraft.host Databases
The red highlighted area is where you can manage any existing databases. Click 'New Database' to create your first!
​
​
In the first box, you assign the database a name. In the box below it, you can restrict MySQL connections. If you don't plan on using it, it's recommended to leave it as % or put it as your server IP. In this tutorial, we will create a database. Pick a name and hit Create Database.
Once you have created the database, it will appear in your list. In order to use it for plugins, simply copy the details it shows into the configuration files for the plugins. Using those credentials, lets give some examples.

Examples

β€’ Luckperms:

1
storage-method: MySQL
2
​
3
# The following block defines the settings for remote database storage methods.
4
#
5
# - You don't need to touch any of the settings here if you're using a local storage method!
6
# - The connection detail options are shared between all remote storage types.
7
data:
8
​
9
# Define the address and port for the database.
10
# - The standard DB engine port is used by default
11
# (MySQL: 3306, PostgreSQL: 5432, MongoDB: 27017)
12
# - Specify as "host:port" if differs
13
address: 168.119.0.38:3306
14
​
15
# The name of the database to store LuckPerms data in.
16
# - This must be created already. Don't worry about this setting if you're using MongoDB.
17
database: s178_test
18
​
19
# Credentials for the database.
20
username: u178_uIxN5UjEZy
21
password: '@CSyH7IV8r4TUnaA3A7lu^2T'
Copied!

β€’ LiteBans

1
sql:
2
# H2, MySQL, MariaDB, and PostgreSQL are supported database drivers.
3
driver: MySQL
4
​
5
## MySQL/PostgreSQL settings ##
6
# If using H2, the database will be stored in the LiteBans plugin folder,
7
# and most of these settings won't apply.
8
​
9
# Database server address.
10
address: 168.119.0.38:3306
11
​
12
# Database name, username and password.
13
database: 's178_test'
14
username: 'u178_uIxN5UjEZy'
15
password: '@CSyH7IV8r4TUnaA3A7lu^2T'
Copied!

β€’ CoreProtect

1
use-mysql: true
2
table-prefix: co_
3
mysql-host: 168.119.0.38
4
mysql-port: 3306
5
mysql-database: s178_test
6
mysql-username: u178_uIxN5UjEZy
7
mysql-password: @CSyH7IV8r4TUnaA3A7lu^2T
Copied!

β€’ Plan

1
Database:
2
Type: MySQL
3
MySQL:
4
Host: 168.119.0.38
5
Port: 3306
6
User: u178_uIxN5UjEZy
7
Password: @CSyH7IV8r4TUnaA3A7lu^2T
8
Database: s178_test
9
# Launch options to append after mysql driver address
10
Launch_options: "?rewriteBatchedStatements=true&useSSL=false&serverTimezone=UTC"
Copied!

β€’ AdvancedBan

1
# If set to false all bans will be saved locally in a HSQLDB-Database
2
UseMySQL: true
3
​
4
MySQL:
5
IP: 168.119.0.38
6
DB-Name: s178_test
7
Username: u178_uIxN5UjEZy
8
Password: @CSyH7IV8r4TUnaA3A7lu^2T
9
Port: 3306
10
Properties: 'verifyServerCertificate=false&useSSL=false&useUnicode=true&characterEncoding=utf8'
Copied!
Remember to switch out the credentials for what you need!