Create a MySQL Database for Bukkit Plugins

Some plugins utilize MySQL databases to store information. We include a dedicated database server with every Minecraft server purchased. You can follow this guide to learn how to create one for the plugins that use it.


Contents

  1. What is MySQL
  2. Creating the Database

What is MySQL

MySQL is a method of storing data in an organized manner which is frequently faster for code to use, especially if humans do not need to be reading the data at all. There are many different types of databases, some have different performance benefits over others, but the main one used by plugins tends to be MySQL.


Creating the Database

  1. Log into Multicraft.
  2. In the side menu on the left side of the screen, expand the Advanced tab.
  3. Select MySQL Database from the side menu.
    Multicraft SQL Menu Entry
  4. If you see a message indicating that there is no database for the server, create a database using the Create Database button on the left side menu.
  5. The information on the page is what the plugin will need to be able to use the database, and let you see the data. The fields are as follows:
    • Host/Address - This is the URL that the plugin will need to be able to find the database.
    • Name - This is the name of the database server, it is unique to your server.
    • Username - This is the name that wil need to be given to the plugin
    • Password - This is a randomly generated password to protect the information in the database so it is not publicly accessible. The plugin will need this to be able to store data.
    • PhpMyAdmin - This is a website that will allow you to see the data stored by the plugins and modify/adjust it manually. Note: Do NOT modify data in the database unless you know exactly what you are doing.
    Using the above information, you can give the plugin that needs the database the information it needs. Most commonly the information needed will be the: Host/Address, Username, and Password
  6. Edit the plugin configuration to give the plugin the correct values. To learn how to edit plugin configurations you can read about it here:
    Editing Plugin Configuration Files (YAML)

Further Reading and External Links


StickyPiston Support

If you use our services or not, we are always happy to help. Open a support ticket and our dedicated team will be in touch.

Open Support Ticket


  • 11 Users Found This Useful

Was this answer helpful?

 Print this Article

Also Read

Editing YAML Configuration Files

Many Minecraft plugins store their configuration settings within text files in the YAML...

How to restore a Minecraft World From a Backup

If you ever need to go back in time with your Minecraft server world, you can do so using...

How To: Set up the Essentials plugin with Group Manager

An overview of the Group Manager permissions plugin. This article will help you install the...

How to Send a Crash Report to StickyPiston

Sometimes crashes keep happening and you just don't have the time or experience to fix...

Help! My Minecraft World Disappeared

If your Minecraft world is gone or the world has changed without you knowing why, this...