How To Add a MySQL Database To Your Minecraft Server

Last modified on Dec 6, 2021 in Control Panel

By ApexHosting

• Facebook
• Twitter
• Youtube

Overview

You may have come across some plugins requiring or allowing the use of a MySQL database. These plugins tend to generate a large amount of data and the most convenient way to store it is through the use of tables, similar to how you would store and manipulate data in a spreadsheet.

For each server you have, you can create a single database and as many tables as needed for your plugins for free. You can quickly create a database by access the respective servers details page and navigating over to the MySQL section on the left side menu. From there you create an manage your database and then use its information to link it to your plugins.
 

Creating a New Database

1. Navigate to the Apex Server Panel.
2. Select MySQL Database from the left-side menu.
3. Click Create Database on the top-left menu to generate a new database.
4. Once created, you will then be presented with details for connecting to the database itself via PHP as well as linking a plugin with it.

Database Details

Most plugins require the same set of information in order to connect with the database. The following is what is presented on the panel along with a brief description.

Hostname (Host) – The IP address where the database is being stored

Database (Name) – Which database to use because a server can have multiple databases

Username – The username with which to use in connecting to the database

Password – Similar to the username, it is used for authentication purposes

Resetting the MySQL DB password

1. Navigate to the Apex Server Panel
2. Select MySQL Database from the left-side menu.
3. Click New Password button on the top-left menu to generate a new MySQL password.

 
When you generate a new password, you will need to update the credentials of any plugin using this information.

Deleting a Database

NOTE: If you have any plugins that are using the MySQL database, they may stop working as intended.

1. Navigate to the Apex Server Panel.
2. Select MySQL Database from the left-side menu.
3. Click Delete Database on the top-left menu to completely remove the database.