Help CenterUsing a MySQL server with a Minecraft server can be a great way to quickly and efficiently store large amounts of data.
It can also be very useful in transferring and syncing data between multiple servers. This can include permissions, economy balances, auction houses, and even inventories. There truly are thousands of plugins that use MySQL for tons of different things in regards to Minecraft servers.
Step 1: Accessing the Control Panel
With your server purchased and the appropriate amount of RAM selected, we can move to adding the modpack to your server. Luckily, this can be done in just a few clicks.
First things first, you will need access the SimpleGameHosting Contol Panel. Then, login to your account.
🤔Need help logging in? If you haven't accessed the SimpleGameHosting Control Panel before, be sure to check out our guide on accessing it for the first time.
Step 2: Creating a Database
Now it is time to set up a new database for your server. While still on the SimpleGameHosting panel,
1. Go to the Settings page from the menu bar.
2. Next, click on the Databases tab in the sub-menu.
3. Then, click the New Database button.
4. Give your new database a name and then click Create Database. Leave the Connections From box blank and confirm by clicking Create Database again.
Once created, you'll see your new database under the Databases tab in your control panel.
Step 3: Getting The MySQL Information
Once the database has been created, it will appear in the list. Click the eye icon next to the new database to reveal the database credentials.
All of this information will be needed later in order to use your database with Minecraft plugins as well as manage it.
Step 4: Managing Your Database With PHPMyAdmin
In order to manage your database, you will need to access it via PHPMyAdmin. This can be done by clicking the little ship icon next to the "New Database" button. Doing so takes you to PHPMyAdmin.
On PHPMyAdmin, you can use the login information you found in step three to login and see your database.
From here, you can create tables, view existing tables, and even export your data.
Step 5: Using Your MySQL Database with Plugins
The primary reason for using MySQL with a Minecraft server is to support certain plugins. MySQL offers a more efficient and organized way to store server data, and it can also allow multiple servers to share and sync information.
While the setup can vary from plugin to plugin, you will always need the username and password from Step 3 to connect to your database. In many cases, you will also need to:
- Set MySQL to true in the plugin’s configuration file
- Enter a Database Name
- Set a Table Prefix or specific table name
Because each plugin handles MySQL differently, it is highly recommended to refer to a tutorial or documentation specific to the plugin you are installing for the best results.
If you need help, don't hesitate to reach out to our support team by submitting a Support Ticket or contacting us directly via LiveChat!