How to Use MySQL Workbench to Edit Your Database
The databases that we create for you are accessible externally by most MySQL editing programs out there. One of the most popular is MySQL Workbench (download: http://www.mysql.com/products/workbench/). We'll be going through the basic functions of MySQL Workbench in this tutorial. The only time you will need to use MySQL Workbench is to delete tables or to make a backup/restore them. Your plugins will automatically create the necessary data tables for you so you will rarely (if ever) need to use this program.
First, download and install the program, then start it up. You will be presented with the following screen:
Click on "New Connection" to add your database.
Fill in the "Connection Name," "Hostname," and "Username" fields with the database info that we provide you with. Hit OK to save the settings.
Your connections list should now show your database. Double click it and you should get a password entry form. Enter your password to access your database.
You can now edit your database tables in the overview menu:
The items with the blue icon (in the red box) are your tables. You can also view the tables on the left side bar under SCHEMAS if they are not listed like in the above image. You can edit and delete the table data by right clicking it.
DELETING A TABLE:
To delete a table (if you need to reset a plugin - some plugins make multiple tables), right click it and select the "Drop Table..." option. This will completely remove your table and allow you to start fresh for that particular data set.
Was this answer helpful?
Most Minecraft plugins offer database storage such as SQLite, H2, or MySQL. Although SQLite and...
First, you'll want to follow the directions here to setup the connection to your MySQL...
This guide will cover the basics on how to export/backup your Minecraft server's MySQL database...