Can I run my own SQL commands in phpMyAdmin?

Yes. Select the database, then choose "SQL" from the menu bar at the top. Enter your SQL commands and click "OK" to run them.

Game Server: phpMyAdmin Access

Q: Can I use external programs instead of phpMyAdmin?

Yes. You can also manage your databases with external MySQL administration programs such as Navicat or HeidiSQL. See the "External Database Access" guide for details.

Learn how to efficiently manage MySQL databases on ZAP-Hosting game servers with phpMyAdmin for seamless database control → Find out more

10 November 20262 min read0 Views0 helpful

Introduction

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.

Logging in to phpMyAdmin

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.

Info

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.

Table tools

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.

Editing table contents

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.

Running SQL commands

You can also run standard SQL commands in phpMyAdmin. First, select the database, then choose "SQL" from the menu bar at the top.

You can then enter any SQL commands you want in the input field and run them by clicking "OK".

FAQ

Frequently asked questions

Open the Databases tab for your game server and click the blue "Manage" button. You’ll usually be logged in automatically. If that doesn’t work, log in manually using the credentials shown.

Yes. Select the tables you want using the checkboxes (or click "Select all"), choose an action from the dropdown menu, and click "OK".

Double-click the field you want to edit. The table must be configured to allow editing, which you can identify by the action buttons displayed.

Feedback

Was this article helpful?

Your feedback helps us prioritize and improve content.

0 of 0 Users found this article helpful.

Personal support

Need more help than the guide provides?

Our ZAP support team knows your product — briefly describe your issue and we'll help you personally.

Which 🍪 cookies would you like to allow?

Game Server: phpMyAdmin Access

Introduction

Logging in to phpMyAdmin

Table tools

Editing table contents

Running SQL commands

Frequently asked questions

Game Server

Logging in to phpMyAdmin

Table tools

Editing table contents

Running SQL commands

Game Server

Servers & Hosting

ZAPX

Resources

ZAP-Hosting