How to Create and Access a Database
In this article, we will guide you through using our databases in WitherHosting to integrate with your Minecraft plugins.
In this article, we will demonstrate creating a database for a plugin called Plan | Player Analytics.
First, navigate to witherpanel.com and then proceed to the databases section in your panel.
Next, click on New Database. This action will generate a database with a username and password.
Ensure to assign a name of your preference, and then select Create Database. Additionally, you can specify which IP addresses to permit connections from. Entering % means any IP address can access the database. This is useful if you want to restrict database access only to your server or certain IPs.
Once created, the database will have information required for access. Click on the eye icon to reveal a window containing essential details such as the username, password, and other relevant information.
You can access your database via two methods!
On your database page, you'll find an icon resembling a database. Simply click on it, and you'll be logged into PHPMyAdmin! Here, you can manage your database rows, tables, import/export databases, and more. Refer to our migration guide for additional information.
HeidiSQL is an excellent SQL software management tool. You can log in by inputting your database credentials. All necessary information is available by clicking on the eye icon to view the database details. In HeidiSQL,
Let's integrate this database information into a plugin. Navigate to your plugin's data folder and open its config.yml. Note that for some plugins, this file might be located elsewhere; check according to the plugin you're using. Enter the IP address, port, username, password, and database name. All information is accessible by clicking on the eye icon to view the database details. Save your changes and restart the server for the plugin modifications to take effect, and your plugin should utilize the database!
That concludes the guide on How to Create and Access a Database! If you have any questions regarding the article, feel free to use the comments section below, and we'll respond promptly! Alternatively, you can join the discussion on our Discord to seek assistance from other members and staff. Thank you for reading this article!
In this article, we will demonstrate creating a database for a plugin called Plan | Player Analytics.
➕ Creating a Database ➕
First, navigate to witherpanel.com and then proceed to the databases section in your panel.
Next, click on New Database. This action will generate a database with a username and password.
Ensure to assign a name of your preference, and then select Create Database. Additionally, you can specify which IP addresses to permit connections from. Entering % means any IP address can access the database. This is useful if you want to restrict database access only to your server or certain IPs.
Once created, the database will have information required for access. Click on the eye icon to reveal a window containing essential details such as the username, password, and other relevant information.
🔓 Accessing Your Database 🔓
You can access your database via two methods!
Automatic Login with PHPMyAdmin
On your database page, you'll find an icon resembling a database. Simply click on it, and you'll be logged into PHPMyAdmin! Here, you can manage your database rows, tables, import/export databases, and more. Refer to our migration guide for additional information.
Login with External MySQL Client (HeidiSQL)
HeidiSQL is an excellent SQL software management tool. You can log in by inputting your database credentials. All necessary information is available by clicking on the eye icon to view the database details. In HeidiSQL,
🔌 Configuring a Plugin to Use Your Database 🔌
Let's integrate this database information into a plugin. Navigate to your plugin's data folder and open its config.yml. Note that for some plugins, this file might be located elsewhere; check according to the plugin you're using. Enter the IP address, port, username, password, and database name. All information is accessible by clicking on the eye icon to view the database details. Save your changes and restart the server for the plugin modifications to take effect, and your plugin should utilize the database!
That concludes the guide on How to Create and Access a Database! If you have any questions regarding the article, feel free to use the comments section below, and we'll respond promptly! Alternatively, you can join the discussion on our Discord to seek assistance from other members and staff. Thank you for reading this article!
Updated on: 30/05/2024
Thank you!