Skip to content
Back to the knowledge base

Databases and phpMyAdmin

Create a MariaDB or MySQL database for your server, find its connection details and manage it in phpMyAdmin.

Databases are useful when a plugin, mod or bot stores its data in a database instead of files. You create the database in the Bazy danych (Databases) tab, and you browse and change its contents in phpMyAdmin.

Creating a database

The client panel is available in Polish only, so this article gives its labels in Polish with a translation the first time they appear.

  1. Open the new database window

    In the client panel, open your server, go to the Bazy danych tab and click Nowa baza danych (New database).

  2. Choose the database type

    Keep MariaDB (domyślny) (MariaDB, default) unless your plugin or bot requires MySQL.

  3. Name the database

    Enter a name in the Nazwa bazy danych (Database name) field. The panel adds a prefix to it, so test becomes s12345_test, for example.

  4. Set the allowed addresses

    Leave Dozwolone połączenia z adresu IP (Allowed connections from IP address) empty to allow connections from any address. Enter an IP address to allow connections only from it.

  5. Create the database

    Click Stwórz (Create).

How many databases you can have depends on your plan. Below the list, the panel shows how many you already have, such as “Utworzono 1 z 1 baz danych” (1 of 1 databases created).

Connection details

The new database appears in the list with its name, address and user.

Click Szczegóły (Details) to see all the details, including the password:

FieldWhat it is
Adres IP (IP address)The database host and port, such as 203.0.113.10:3306. The database port is the number after the colon, not the game port.
Dozwolone połączenia z (Allowed from)The addresses that can connect. The % sign means any address.
Użytkownik (User)The database login.
Hasło (Password)The database password, separate from your account password.
Ciąg połączenia JDBC (JDBC connection string)All the details in one line, for plugins that ask for it.

A plugin, mod or bot usually asks for the host, port, database name, user and password. Copy them from this window into its configuration file. If the password leaks, click Zresetuj hasło (Reset password) and enter the new one everywhere you connect to the database.

Logging in to phpMyAdmin

  1. Open the login instructions

    In the database list, click phpMyAdmin. The panel shows the Instrukcje logowania (Login instructions) window with the user and password for this database.

  2. Open phpMyAdmin

    Click Otwórz phpMyAdmin (Open phpMyAdmin). The login page opens in a new tab, with the Wybór serwera (Server choice) field already set.

  3. Log in

    Enter the Użytkownik and Hasło from the instructions window and click Login.

Importing a database from a file

Importing loads an .sql file into the database, such as a backup of a database from another host. You can switch phpMyAdmin to English in the language list on its login page.

  1. Open the database

    In phpMyAdmin, click the database's name in the tree on the left.

  2. Choose the file

    Go to the Import tab and choose the .sql file on your computer. The file can be up to 100 MB and can be compressed, such as .sql.zip.

  3. Import

    Keep the SQL format, scroll to the bottom of the page and click Import. After a successful import, phpMyAdmin shows a success message.

Exporting a database to a file

Exporting saves the database as an .sql file on your computer. Do it before bigger changes to the database.

  1. Open the export

    In phpMyAdmin, click the database's name and go to the Export tab.

  2. Download the file

    Keep the quick export method and the SQL format, then click Export.

Deleting a database

In the panel's database list, click Usuń (Delete), enter the database's full name, such as s12345_test, and confirm with Usuń.

Common problems

A plugin can't connect to the database

Check that the plugin's configuration uses the database port from the Adres IP field in Szczegóły, not the game port, and that the database name includes its prefix, such as s12345_test. If Dozwolone połączenia z has a specific address instead of %, other addresses can't connect.

There's no Nowa baza danych button

Your plan already has as many databases as it allows. Delete a database you don't use or move to a bigger plan with Zmień pakiet (Change plan) in the Przegląd (Overview) tab.

The import fails or stops

Compress a file larger than 100 MB to .sql.zip or .sql.gz. If the import still fails, write to us through the contact form and include the error message.