This guide will help you understand what a MySQL database is and what it is used for.
❓ What Is a MySQL Database and what is it used for ❓
MySQL is one of the most popular database systems, widely used in applications, websites, and Minecraft plugins and mods.
You can use a MySQL database with multiple plugins or mods to store information regarding your server (like the inventory or ranks of players) as long as the plugin permits it.
Some examples of plugins that work with a MySQL database are:
- LuckPerms
- CoreProtect
- AdvancedBan
The advantages of MySQL over other storing alternatives (like storing in text) are that the MySQL database is faster, more efficient, and has a lower chance of data loss.
Also, using a MySQL database comes in handy when you are running a BungeeCord server, because you can use one database for all of your servers.
How to Get a MySQL Database
To be able to use a MySQL database, you must verify if your plan includes one. The MySQL database can be added either in the order process or later if you change your mind and decide it is needed.
To get a the database for an existing server, just open a ticket under your billing account requesting it, and our team will take the necessary actions.
The price for the MySQL database is $2 per month.
️ How to Create a MySQL Database ️
If you already have a MySQL database included on your server plan, all you have to do is create it.
You can do so by following the next steps:
- Log in to your Multicraft panel here.
- Click on
Advanced
, then onMySQL Database
, then onCreate Database
.
- Now you’ve created the database. Now you can note the connection information to be able to use them for any plugin or mod you want. (
Host
,Name
,Username
, andPassword
).
❌ How to Delete a MySQL Database ❌
You are able to delete the existing MySQL database assigned to your server at any time.
If you ever want to remove your existing MySQL database, you can do so by following the next steps:
- Log in to your Multicraft panel here.
- Click on
Advanced
, then onMySQL Database
, then onDelete Database
.
Now you’ve just removed your existing database.