This guide will help you add MySQL databases to your server
Want to add databases to your game server? Below we will show you how to do just that
go to the panel and create a new database as shown below
After creating the database click the eye that will show you the details of your database
Download MySQL Workbench here and install. MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system
after running the workbench click the database sections and Connect to Database
Enter the details from the panel to the workbench to connect
and congratulations you have just connected to the MySQL database
Examples
• Luckperms:
storage-method: MySQL# The following block defines the settings for remote database storage methods.## - You don't need to touch any of the settings here if you're using a local storage method!# - The connection detail options are shared between all remote storage types.data: # Define the address and port for the database. # - The standard DB engine port is used by default # (MySQL: 3306, PostgreSQL: 5432, MongoDB: 27017) # - Specify as "host:port" if differs address: 168.119.0.38:3306 # The name of the database to store LuckPerms data in. # - This must be created already. Don't worry about this setting if you're using MongoDB. database: s178_test # Credentials for the database. username: u178_uIxN5UjEZy password: '@CSyH7IV8r4TUnaA3A7lu^2T'
• LiteBans
sql: # H2, MySQL, MariaDB, and PostgreSQL are supported database drivers. driver: MySQL ## MySQL/PostgreSQL settings ## # If using H2, the database will be stored in the LiteBans plugin folder, # and most of these settings won't apply. # Database server address. address: 168.119.0.38:3306 # Database name, username and password. database: 's178_test' username: 'u178_uIxN5UjEZy' password: '@CSyH7IV8r4TUnaA3A7lu^2T'
• CoreProtect
use-mysql: truetable-prefix: co_mysql-host: 168.119.0.38mysql-port: 3306mysql-database: s178_testmysql-username: u178_uIxN5UjEZymysql-password: @CSyH7IV8r4TUnaA3A7lu^2T
• Plan
Database: Type: MySQL MySQL: Host: 168.119.0.38 Port: 3306 User: u178_uIxN5UjEZy Password: @CSyH7IV8r4TUnaA3A7lu^2T Database: s178_test # Launch options to append after mysql driver address Launch_options: "?rewriteBatchedStatements=true&useSSL=false&serverTimezone=UTC"
• AdvancedBan
# If set to false all bans will be saved locally in a HSQLDB-DatabaseUseMySQL: trueMySQL: IP: 168.119.0.38 DB-Name: s178_test Username: u178_uIxN5UjEZy Password: @CSyH7IV8r4TUnaA3A7lu^2T Port: 3306 Properties: 'verifyServerCertificate=false&useSSL=false&useUnicode=true&characterEncoding=utf8'
Remember to switch out the credentials for what you need!
Free Minecraft Tools
Speed up your server with our free Minecraft tools:
Ready to play?
Run your own Minecraft server with XGamingServer
Spin up an always-on Minecraft server your friends can join in minutes — no port-forwarding, no tech headaches.
