Configure plugins which need a MySQL database

From Nitradopedia EN
Jump to: navigation, search
Minecraft wiki.jpg
Rent your own prepaid Minecraft server on nitrado.net


This article explains the basic configuration of MySQL connections for most plugins using LogBlock as an example. The procedure is nearly the same for every plugins so you should find oyur way around even if you don't use LogBlock.

Install the plugins as usual, if you do need help at with this step we do also offer a tutorial: How to install Bukkit plugins

The plugin will create a configuration file (config.yml) which can be found in the plugin's folder (minecraftbukkit/plugins/LogBlock) if installed correctly. We do recommend Notepad++ for editing .yml files because it makes things much easier.

The config should look like this:

   loggedWorlds:
   - world
   - nether
   tables:
   - lb-main
   - lb-nether
   mysql:
   port: 3306
   host: localhost
   password: pass
   user: username
   database: minecraft
   [........]

Navigate to your server's Webinterface and click on the "MySQL DB" menu option to view your credentials. You may now place this information in the plugin's configuration like this:

   loggedWorlds:
   - yourworldname
   - nether
   tables:
   - lb-main
   - lb-nether
   mysql:
   port: 3306
   host: localhost
   password: PASSWORD
   user: niXXXX_1_DB
   database: niXXXX_1_DB


PASSWORD will be replaced by your MySQL password.
niXXXX_1_DB will be replaced by your MySQL database name.
niXXXX_1_DB will be replaced by your MySQL username.
yourworldname will be replaced by your world folder's name or the value of "level-name=" in your server's configuration file (server.properties).


Now you are set and ready to go!