Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more

To connect a Minecraft plugin to MySQL, create a database and a separate user, select MySQL (or the plugin’s MariaDB driver) in the plugin settings, enter the server address, port, database name and credentials, then restart the Minecraft server and read the startup log. The exact key names and file location differ between plugins, so the plugin’s current documentation is the final authority.

This guide applies to Paper and Spigot servers and covers the common pattern, hosted control panels, manual VPS setup, multi-server networks, secure credentials, and the errors that most often prevent a connection.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

What you need before changing a plugin

Have these items ready before editing a file:

  • Access to the Minecraft server files and permission to stop and start the server.
  • Access to a MySQL- or MariaDB-compatible database, either from your game-hosting panel or on a VPS.
  • The plugin’s documentation or a freshly generated configuration file. Do not assume every plugin uses config.yml.
  • The database host name or IP address, TCP port, database name, username and password.
  • For a remote database, firewall rules that allow the Minecraft host to reach the database host on the database port.

MySQL and MariaDB are separate database engines, although many Minecraft plugins support both through a selectable driver. A plugin that specifically asks for a MariaDB driver should not be configured with a guessed MySQL driver name.

Decide whether MySQL is the right storage method

One Paper or Spigot server

A single server often works perfectly with the plugin’s default flat-file storage, such as YAML or SQLite. MySQL adds a separate service, credentials and backup responsibility. Use it on one server when the plugin requires it, when its data set is large, or when you need database administration and reporting.

#1 Best Overall
Sale
Compressed Air Duster,130000RPM Super Power Cordless Air Duster,Rechargeable Brushless Blower,3 Gear Adjustable Blower with LED Light,Dust Remover for Computer/House/Outdoor/Car
  • Powerful Turbo Fan:CAGIWIRU Electric Air Duster have reached speed up to 130000RPM,Can efficient remove dust and debris.With LED light and Three Adjustable Speed to meet with different cleaning tasks.
  • With Attached USB C Fasting Charging cable.Charing 3 hours,Enjoy up to 240 minutes of use on the lowest setting, For third speed can use for 25mins.with four charging options to meet with your needs.
  • Wide Application:Upgraded attached 5 different nozzles,making it suitable for a variety of scenes, such as car,pet, pc, keyboards, and other electronic devices. It also serves for office and home clean duster.
  • Handy Design & Portable:Cordless air duster electric nozzle is Light weight and small size, design and comfortable to hold and space saving, convenient to carry around. You can put it in your room or inside the car without taking up space.
  • Warranty & Support: Our Electric air duster comes with 5 years warranty and 24/7 customer service. During this period, if you have any questions,pls kindly feel free to contact us.

A BungeeCord or Velocity network

MySQL is most useful when several Minecraft servers must read and write the same data. A shared database can let compatible instances use common points, punishments, profiles or other plugin records. Every instance still needs a compatible plugin version and its own correctly configured connection. A database alone does not make unrelated plugins share data.

Hosted panel or self-managed database

Setup What the provider or administrator does What you still must verify
Game-hosting panel The panel commonly creates a database and user together and displays the connection values. Whether the displayed host is local or remote, which port is required, whether remote connections are allowed, and whether the generated user has enough privileges.
VPS or dedicated database host You create the database, account, grants, firewall rules and backups yourself. That the database service is listening on the intended interface and that only the Minecraft host can reach it.

Create a database and a dedicated user

Using a hosting panel

  1. Open the panel’s database section and choose MySQL or MariaDB.
  2. Create a new database with a name you can identify with this plugin.
  3. Create a new database user and generate a strong password.
  4. Attach that user to the database. Grant only the permissions the plugin needs; do not reuse the panel’s administrative account.
  5. Copy the panel’s host, port, database name, username and password exactly. Some panels prepend an account or server identifier to the database and user names.

Panels sometimes show localhost for a database that is actually on a separate internal host. Use the value supplied for the game server, not a value inferred from another installation.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Using SQL on a VPS

Log in to the database administrator account through a protected local session, then create an isolated database and account. Replace the example names with your own values:

Rank #2
EVEO® Screen Cleaner Spray Kit (Streak-Free) TV Screen Cleaner for Smart TV, Lcd, LEd, Oled | Computer Screen Cleaner Spray and Wipe Microfiber Cloth - TV, Monitor, Laptop, iPad, Car - 6.7oz 1 Pack
  • Screen Cleaner is Your Screen’s New Bestfriend! - EVEO is proud to present a screen cleaner that’s perfectly suited for your TV. Meet your new screen cleaner, computer screen cleaner, laptop cleaner, iPad cleaner, Macbook,tv cleaner or any other electronic device. Our screen cleaner spray and wipe along with the included plush microfiber cloth, easily removes dust, fingerprints & other smudges on the screen’s surface. Clean effectively for a streak-free screen
  • Gentle on your Screens - Our screen cleaner spray and wipes is compatible to be used even for the most sensitive LCD, LED, CRT, and OLED screens in proper use. Be at ease knowing that this product is compatible with all the major brands: LG, SONY, Samsung, Sharp, iPad, iPhone, Android screens, Kindle, PC monitors - we’ve got you covered! Can be used as LCD screen cleaner, tv cleaner, smart tv screen cleaner, and more
  • Premium Super Soft Plush Microfiber Cloth - Included in this efficient screen cleaning kit. This screen cleaner spray and wipe has our signature plush microfiber cloth specially designed to comply with screens and monitors and leave them streak-free. Has been shown to effectively absorbs stubborn stains, zero streaks, and no fiber shedding. Always use this together with our screen cleaner for the best results
  • Easy-to-Use Screen Cleaner Kit + microfiber cleaning cloth - The EVEO Screen Cleaning Kit will easily be your new favorite tool when it comes to taking care of the things you love most, quick and easy solution for a streak-free screen. Simply screw on the sprayer gun on the screen cleaner bottle. Spray the cleaning liquid onto the microfiber cloth, then wipe the screen until desired cleanliness & shine is achieved.
  • Quality Screen Care Kit Worth Purchasing - Enjoy a convenient Screen Cleaner anytime, anywhere you need it. Your satisfaction is our top priority. We stand behind the quality of our products and that’s why, you shouldn’t be worrying at all. We manufacture the Best Screen Cleaner. and can be used for laptop cleaning kit, laptop screen cleaner, tv screen cleaner for smart tv. MacBook screen cleaner, monitor cleaner or screen cleaner spray for electronic devices with microfiber cleaning cloth
CREATE DATABASE minecraft_plugin CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'minecraft_plugin_user'@'YOUR_MINECRAFT_HOST' IDENTIFIED BY 'use-a-long-random-password';
GRANT ALL PRIVILEGES ON minecraft_plugin.* TO 'minecraft_plugin_user'@'YOUR_MINECRAFT_HOST';
FLUSH PRIVILEGES;

If the Minecraft server and database run on the same machine, the account host may be localhost. If they are separate, use the Minecraft server’s IP address or another narrowly scoped host pattern supported by your database administrator. Avoid granting access from every address unless there is no safer alternative and a firewall provides equivalent restriction.

The exact privileges vary by plugin. A plugin that creates and alters its own tables may need table-definition privileges during installation or upgrades. After checking the plugin documentation, you can reduce permissions if the plugin supports a read/write account without schema-management rights.

Find the plugin’s actual configuration file and keys

Stop the server before making structural configuration changes, or use the plugin’s documented reload procedure if it explicitly supports one. Most plugins store settings under plugins/<PluginName>/ and commonly use config.yml, but that is not universal.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Rank #3
BladeHawks RGB Gaming Mouse Pad Extra Large Extended 31.5x12 Inch-Black
  • 【Large size】:Measuring 800 x 300 mm/ 31. 5×12 inches, which is wider and taller than others. Large mouse pad can perfectly fit your keyboard and mouse of any size, and there is also ample space for peripherals such as phones, tablets, etc.
  • 【LED backlight mouse pad】:Blade Hawks RGB mouse pad provides 7 static modes and 7 dynamic modes will give you the options you are looking for. Power-off memory function remembers the last lighting mode you selected. The super glow fiber Chroma will give you a colorful gaming setup that you want.
  • 【Anti-slip rubber base】:Made from Natural rubber, this gaming mousepad will firmly grip your desktop, allowing you to enjoy the ultimate precision in the games you are most passionate about. It also comes with a texture that enhances this ability even further.
  • 【Smooth and waterproof surface】: Micro-textured cloth surface, for extremely precise mouse control and a smooth movement. When liquid splashes on the gaming mouse pad, it forms water droplets and slides down. Will not delay your work or gameplay.
  • 【Plug and play】: This mouse and keyboard pad is powered by USB, plug and play, no driver required. One button control light modes. Press one time to change the lighting mode, press twice to change the brightness, press and hold about 3 seconds turn ON/OFF.
  • General pattern: plugins/<PluginName>/config.yml.
  • MySqlPlayerBridge: its database settings are in plugins/MySqlPlayerBridge/mysql.yml, not the usual config.yml.
  • LiteBans: its settings include a driver choice of MariaDB plus address, database, username and password fields.
  • PlayerPoints: use the plugin’s own configuration page on dev.bukkit.org as the key reference rather than copying a configuration from another plugin.

Search the generated file for terms such as storage, storage-method, database, driver or mysql. Do not add a new key with a plausible name if the file uses a different schema: unknown keys are usually ignored.

Change flat-file storage to MySQL

Make a backup of the plugin folder before editing. Preserve indentation and use the exact spelling and capitalization shown by the plugin. An illustrative configuration looks like this; the names are examples, not a universal schema:

storage-method: mysql
data:
  address: "127.0.0.1:3306"
  database: "your_db_name"
  username: "your_db_user"
  password: "your_db_password"

Some plugins use a nested mysql: section, separate fields for host and port, or a driver value such as MariaDB. Follow that plugin’s template exactly. If it asks for an address containing the port, include it in the same value, for example 127.0.0.1:3306. If it provides separate host and port keys, do not append the port to the host field as well.

Rank #4
Sale
Vaydeer Wrist Rest for Keyboard and Mouse, Computer Ergonomic Wrist Support Pad, Soft Memory Foam Arm Cushion for Desk, Palm Hand Office Laptop Typing
  • 【Softer and More Comfortable】Vaydeer wrist rest has unique diamond pattern, which is the combination of softness and aesthetics. The materials of wrist rest are improved into higher quality memory foam and covered with silky smooth lycra. The computer wrist rest makes you as comfortable and cushiony as like rest your wrists on clouds.
  • 【Ergonomic Wrist Saver】The wrist rests for keyboard and mouse comes with a 17.32×3.15×0.83 inch keyboard wrist pad and a 5.94×3.15×0.83 inch mouse wrist support. Based on ergonomic design, the unique concave shape is the perfect fit for your wrist joints. The wrist rest pad fits most computer keyboards and laptops, improve hand and wrist posture, release your wrist and arm stress.
  • 【Non-Slip Rubber Bottom】Featuring an anti-skid silicone base on the bottom, this wrist keyboard support stays firmly in place on your desk, preventing the padding from sliding around, ensuring stable and consistent wrist support during extended computer sessions.
  • 【Better Experience & Pain Relief】Our keyboard arm rest is beneficial to alleviate the soreness caused by direct contact and friction between your arm and a hard desk surface, reducing the risk of wrist fatigue or carpal tunnel. The soft texture of memory foam can evenly distribute the pressure around your wrists and provide good support with just enough give.
  • 【Helpful in Multiple Scenarios】Whether you're working, studying, writing, typing, gaming, this keyboard and mouse rest combo is an essential accessory to add comfort and support to your hands and wrists. It’s also a great gift for men, women, family, friend, coworker, gamer, teacher, etc.

Why quoting matters in YAML

Quote the host-and-port value and the password. YAML treats characters such as :, #, braces and some leading symbols specially. A password containing a colon, hash or leading punctuation can be parsed incorrectly when left bare. Quoting also prevents an all-numeric-looking value from being interpreted as another YAML type.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Do not put a space before or after a password unless that space is genuinely part of the password. Do not paste an encrypted or masked panel value if the panel has a separate “copy” control that reveals the actual credential.

Restart and verify the connection

  1. Save the file using UTF-8 text and confirm that the edited file is in the active server directory.
  2. Start or restart the Minecraft server. A full restart is safer than a plugin reload when the database driver is loaded during startup.
  3. Watch the console from the beginning of the boot process. Look for a successful connection, schema creation or migration message from the plugin.
  4. Test a real plugin action, such as creating a record or changing a setting, then stop and start the server again to confirm the data persists.
  5. If the plugin reports an error, record the first database-related message and its underlying cause. Later stack-trace lines are often consequences rather than the root problem.

A successful connection message only proves that the credentials and network path worked. It does not prove that the account has every permission needed for table creation or future upgrades, so perform the plugin action that writes data.

Best Value
Sale
Under Desk Cable Management Tray No Drill, Metal Mesh Cable Management Under Desk with Clamp Mount, 2 Hole Cable Tray with Wire Management and Cord Organizer for Home Office Standing Desk
  • 【No Drill Mounted】Cable management tray can be assembled in as little as 3 minutes or less-simply. Side clips easily clampe the edge of desk, pass through the holes on the sides, and secure excess cables with baskets. Desk cable management supports inward or outward installation to meet your needs in different scenarios, and provides you with great convenience when collecting and organizing wires.
  • 【Rubber Pad Protects Desk】Wire organizer under desk built-in soft rubber pads on the clamp protect your desk from scratches, so you will not damage your furniture or office.
  • 【Sturdy and Beautiful】Cord management under desk is made of high-quality carbon steel and holds about 15 lbs. The wire basket has 2 holes on each side of the tray to enable your cables to pass freely. Cable baskets are suitable for desk thickness use from 0.4" to 2.4".
  • 【Space Saving & Keep Organized】Desk cable management tray holds all your power cords, outlet strips, USB hubs and computer transformers hidden from your feet, and the data cables will not enter the vacuum cleaner to keep your desk clean and tidy. Desk wire organizer is also suitable for use in the kitchen and outdoors.
  • 【Reduce Safety Risks】Cable tray under desk keeps all plugs away from your kids, no more worry about tripping. Using 2 holes wire tray saves extra space, helps you easily cabling and wire protection. The mesh design is not easy to accumulate dust, but avoids safety accidents caused by messy wires.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Configure a multi-server network safely

For BungeeCord or Velocity networks, decide which data should be global and which should remain per-server. Point only compatible plugin instances at the same database and use the plugin’s documented synchronization settings. Some plugins require an explicit network or shared-storage option in addition to MySQL.

  • Use one database or schema per plugin unless the plugin documentation says otherwise.
  • Use a consistent plugin version and configuration format on every server.
  • Ensure every server can resolve the database host and reach its port.
  • Do not let two different plugins write to the same tables merely because they both use MySQL.
  • Plan for simultaneous writes; a database connection does not remove the need for the plugin to implement locking or conflict handling.

Keep proxy and backend servers on the same trusted network where possible. If the database is outside that network, use firewall allow-lists and encrypted transport when the database and plugin support it.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Common connection errors and fixes

Symptom Likely cause Checks and fix
“Connection refused” or a timeout The host or port is wrong, the database service is stopped, or a firewall blocks the route. Confirm the panel’s address and port, verify that MySQL or MariaDB is listening, and allow traffic from the Minecraft server. Do not switch to a random port without changing the database service and firewall consistently.
“Unknown host” The hostname cannot be resolved by the Minecraft machine. Check spelling and DNS, then try the provider’s documented IP only if it is intended to be stable. A local database may use 127.0.0.1 or localhost, but those values are not interchangeable with a remote host.
“Access denied for user” The username, password or account host restriction is wrong, or the user has not been granted access to this database. Re-copy the credentials, check the account’s allowed host, attach the user to the correct database and reapply the grant. Do not solve it by using an administrator account.
“Unknown database” The database name is misspelled or the panel added a prefix. Copy the exact database name from the panel or list databases as an administrator. Names are not necessarily the same as the display label.
YAML parsing error Bad indentation, an unquoted special character or a malformed value. Restore the plugin’s generated file, edit only the documented values, use spaces rather than tabs and quote the address and password.
Driver or class-not-found error The plugin expects a different driver value or its database driver is missing. Use the driver spelling required by the plugin. LiteBans, for example, documents a MariaDB driver setting; do not substitute a generic value without checking its configuration reference.
Connection succeeds but tables are not created The account can connect but lacks schema or table privileges, or the plugin is still set to flat-file mode. Confirm the storage selector, inspect the database for new tables and grant the documented permissions needed for first-run setup.
Data appears to vanish after switching The plugin is reading a new empty database; existing flat-file data was not imported. Stop the server, restore the previous plugin-folder backup if necessary and follow the plugin’s documented migration process. Changing the storage key alone should not be treated as a migration.

Security and operational practices

Protect the credential

  • Use a dedicated account for each plugin or closely related deployment.
  • Choose a long, random password and keep it out of public paste sites, screenshots and version-control repositories.
  • Restrict the account’s allowed source host and the database port’s firewall access to the Minecraft server.
  • Give the account only the privileges documented by the plugin. Administrative database accounts are unnecessary for normal operation.
  • Rotate the password by updating the database account and the plugin configuration during a maintenance window.

Back up before migrations and upgrades

Back up both the plugin directory and the database before changing storage type, upgrading the plugin or changing its schema. A file backup alone does not protect records already stored in MySQL. Test that a backup can be restored to a separate database before relying on it.

Keep versions and settings aligned

Read the plugin’s current documentation whenever its configuration is regenerated. Key names, supported drivers and migration behavior can change between releases. Do not copy a configuration from an older server without comparing it with the newly generated template.

Migration checklist from flat files

  1. Stop the server and copy the complete plugin directory.
  2. Export or otherwise back up the existing flat-file data.
  3. Create the MySQL database and least-privilege user.
  4. Check whether the plugin documents an import or migration command. If it does not, ask the plugin author before assuming that changing the storage setting will copy records.
  5. Enter the database values, quote the address and password, and change only the documented storage keys.
  6. Start the server and inspect the log for schema creation, migration or errors.
  7. Verify representative records in-game, stop and restart again, then confirm they remain available.
  8. Keep the old backup until the new database has been tested and included in your normal backup schedule.

Quick final checklist

  • Database exists and its name is copied exactly.
  • Dedicated user exists, has the required grants and is allowed from the Minecraft host.
  • Host and port are correct for this server; remote addresses are not replaced with localhost accidentally.
  • Plugin storage mode is MySQL or the documented MariaDB option.
  • Configuration file and key names match this plugin, including plugins that use mysql.yml.
  • Host-and-port and password values are quoted in YAML.
  • Server was fully restarted and the startup log was checked.
  • A real write-and-restart test succeeded.
  • Database and plugin-folder backups are scheduled and protected.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.