How to Create and Connect a MySQL Database
How to create a database from the panel and connect to it from a plugin, mod, or external tool.
How to Create and Connect a MySQL Database
Plugins with economy systems, stats tracking, or cross-server data (and most web apps) need a real database, not flat files. Here's how to create and connect to one on your RepublicNodes plan.
Creating a Database
- Go to your service's Databases tab.
- Click New Database and give it a name (it'll usually get prefixed automatically to keep it unique on the shared MySQL server).
- The panel generates the database, a dedicated username, and a random password automatically โ you don't set these manually.
- Click the database in the list to reveal its full connection details: host, port, database name, username, and password.
How Many You Get
Your plan includes a set number of database slots โ check your product page (it ranges from 1 on entry Budget tiers up to 3 on most Performance tiers). Each is a fully separate database with its own credentials, not just a schema inside one shared database.
Connecting to It
- From a plugin/mod: most plugins that support MySQL ask for host, port, database, username, and password in their own config file โ copy the exact values from the Databases tab, don't retype them by hand (easy to introduce a typo in a generated password).
- From an external tool (DBeaver, HeidiSQL, phpMyAdmin-style clients, etc.): use the same host/port/credentials. Depending on your plan, the database host may only be reachable from your own server's IP for security โ check the connection details panel for whether external access is enabled, and use the built-in phpMyAdmin/Adminer link if one is shown for browser-based access without extra setup.
- Resetting the password: if credentials ever leak or you just want a fresh password, there's a rotate/reset option next to the database โ update it in your plugin config immediately after, since the old password stops working the moment you do this.
Common Gotchas
- Database names and usernames are usually auto-generated with a prefix you can't fully customize โ if a plugin's default config assumes a specific database name, you'll need to edit that config to match what the panel actually created.
- Deleting a database from this tab is immediate and permanent โ there's no separate confirmation beyond the initial prompt, and no built-in undo.
- If a plugin can't connect, double-check you copied the host correctly โ it's very often not
localhoston a panel-managed database, even though that's the default most plugin configs ship with.
Real MySQL, not a toy โ this is the same database engine you'd get self-hosting your own server, just provisioned and credentialed for you automatically.