With phpMyAdmin, you can quickly and easily manage MySQL databases through a web interface. ZAP-Hosting includes MySQL databases with its game server products. You can manage them using phpMyAdmin or external MySQL administration programs such as Navicat or HeidiSQL. We also have a guide for this, which you can find under External Database Access.
First, let's go to the list of databases created for the game server. To do this, open the Databases tab for your game server.
This page lists all databases for this server. Logging in to phpMyAdmin is quite easy because our system handles the login automatically. You just need to click the blue "Manage" button.
If the login does not work automatically, you will need to log in manually using the relevant credentials. You can find this information in the area highlighted in red in this example.
Initially, only the phpMyAdmin home page is displayed. To view and edit a database's tables, you need to open the database:
All the database's tables and several tools for performing specific actions are now displayed. For example, you can delete tables by clicking the red "Delete" button.
To save time, you can also apply actions to multiple tables at once. Click the checkbox on the far left, and repeat this until all the tables you want are selected. If you want to apply the action to every table in the database, you can also use the "Select all" button, which automatically selects every table. Then choose the action you want from the dropdown menu and click "OK" to apply it.
You can quickly and easily edit values in a table by double-clicking the relevant field. The table must be configured to allow editing. You can tell this is the case by the three action buttons that appear.