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, go to the Advanced section.
3. Select MySQL Database from the side menu.
   
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

• Editing Plugin Configuration Files (YAML)

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