Skip to main content

External database access

Introduction​

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.

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:

image

Preparation​

First of all we need a Software, in this example we're showing Navicat or HeidiSQL 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.

HeidiSQL​

In order for the connection to be established in HeidiSQL, we create a new connection with "New".

image

At Hostname / IP, we enter the name of your database, in our example "mysql-mariadb-5-101.zap-hosting.com". User name and password are also to be taken from the data, port remains on 3306.

After that we just click "Open"

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. image