Database Management

Database management allows you to create MariaDB databases and database users, reset passwords and access your databases directly via phpMyAdmin.

---

Overview

The database table shows all your databases:

Column	Description
Name	Database name
User	Associated database user
Server	MariaDB server
Size	Current storage usage
Created	Creation date

---

Create Database

1. Click Create Database
2. Fill out the form:

Field	Required	Description
Name	Yes	Database name (automatically prefixed)
Password	Yes	Password for the database user

1. Click Create

Naming Convention

Database names are automatically prefixed with your customer prefix (e.g. c1_my_db). This ensures there are no naming conflicts with other customers.

After creation, you receive the access credentials:

Information	Description
Database	Full database name
User	Username for the connection
Password	The entered password
Host	localhost (for PHP connections)
Port	3306

---

Reset Password

1. Click the key icon next to the database
2. Enter a new password or have one generated
3. Click Save

Update Applications

After a password change, you must also update the password in your web application's configuration (e.g. in wp-config.php for WordPress).

---

Database Users

View Users

1. Click on a database
2. In the Users section, you can see all associated database users with their permissions

Create User

1. Click Add User in the users section
2. Fill out the form:

Field	Required	Description
Username	Yes	Name of the new database user
Password	Yes	Password for the user
Permissions	Yes	Desired database privileges (e.g. SELECT, INSERT, UPDATE, DELETE)

1. Click Create

Reset User Password

1. Click the key icon next to the user
2. Enter a new password
3. Click Save

Delete User

1. Click the delete icon next to the user
2. Confirm the deletion

---

phpMyAdmin

phpMyAdmin enables graphical management of your databases directly in the browser — execute SQL queries, edit tables, import and export data.

Log In

1. Click the phpMyAdmin icon next to the desired database
2. You are automatically logged in via Single Sign-On (SSO)
3. phpMyAdmin opens in a new tab

Automatic Login

You don't need to log in separately. The panel generates a one-time token that automatically authenticates you. This token is valid for 60 seconds and can only be used once.

phpMyAdmin Features

Feature	Description
SQL Queries	Execute arbitrary SQL commands
Manage Tables	Create, edit, delete tables
Import Data	Upload and import SQL dumps
Export Data	Download the database as .sql or .sql.gz
Search	Search for values across all tables

Only Your Own Databases Visible

In phpMyAdmin, you can only see your own databases. Other customers' databases are not accessible.

---

PostgreSQL

In addition to MariaDB/MySQL, you can also select PostgreSQL as the engine when creating a database. Creating, resetting passwords, and backups work exactly the same as with MySQL.

Permission

Whether PostgreSQL is available depends on your hosting package. Ask your provider if needed.

---

Adminer

For your PostgreSQL databases, you use Adminer instead of phpMyAdmin — the graphical management in the browser works the same way.

1. Click the Adminer icon next to your PostgreSQL database
2. You are automatically logged in via Single Sign-On (SSO)
3. Adminer opens in a new tab

phpMyAdmin remains the tool for MySQL, Adminer is the tool for PostgreSQL.

---

Delete Database

1. Click the delete icon next to the database
2. Confirm the deletion in the dialog

Irreversible

Deleting a database permanently removes all tables and data. Create a backup beforehand via phpMyAdmin (Export) or the panel's backup feature.

---

Connection from PHP

Use these credentials in your PHP application:

<?php
$host     = 'localhost';
$port     = 3306;
$dbname   = 'c1_my_db';          // Your database name
$username = 'c1_my_db';          // Your database user
$password = 'YourPassword';      // Your database password

$pdo = new PDO(
    "mysql:host=$host;port=$port;dbname=$dbname;charset=utf8mb4",
    $username,
    $password
);

Passwords Not in Code

Ideally, store database passwords in a separate configuration file (e.g. .env) that is not in the Git repository.