External database access
ZAP-Hosting offers MySQL databases inclusive for the gameserver products. These can be managed either internally via phpMyAdmin or externally via MySQL administration tools such as Navicat or HeidiSQL. In the following the setup and administration of the database is explained by using Navicat.
First of all the Navicat software is necessary. In addition to the Premium version, there is also a Lite version available. It can be downloaded here: Download Afterwards the downloaded file must be executed and the setup procedure has to be followed. When this step is completed, the program can be started and the connection to the database configurated.
The user credentials to access the database are required for this purpose. Those can be found in the game server administration under databases. For this you need the information regarding server/IP, database, user, password and the default port 3306:
In order to establish the connection in Navicat we create a new connection. Under Connection we select MySQL. Afterwards another popup window opens where the database information must be inserted.
The Connection Name is only used for the overview of the databases and can therefore be chosen as desired. All other information is taken from the interface as described above. Afterwards we click on OK and the setup is finished. The connection can then be established on the left in the database overview. To do so, double click on your database or right click once and choose "Open connection":
Afterwards the database opens with all existing database tables. There your can now modify or manage your database similar to phpMyAdmin by click as well as by using SQL commands.