What Is a MySQL Database and What Is It Used For?
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.
Here is our guide explaining BungeeCord.
🔌 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.
Here is our guide for opening a ticket.
The price for the MySQL database is $2 per month.
Also, the database came free for premium services or standard ones with billing cycles longer than 3 months (quarterly).
🛡️ 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 on MySQL Database, then on Create 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, and Password).
❌ How to Delete a MySQL Database ❌
You are able to delete the existing MySQL database assigned to your server at any time.
⚠ NOTE ⚠: Deleting a database will also remove all information present on it (such as plugin data) without the option to get it back.
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 on MySQL Database, then on Delete Database.
Now you've just removed your existing database.
If you have any issues or questions regarding the MySQL database, please contact us on live chat or via the ticket system.
❕Useful Links❕
- How to Upgrade or Downgrade Your Service
- Addons - General Information and How to Order One
- Premium Support Addon
Updated on: 10/06/2022
Thank you!