Databases

Many sites (WordPress, online shops, business applications) store their data in a database. The panel creates MariaDB databases, compatible with MySQL.

Creating a database

1. Open Databases and choose New database (or, from the site page, the Databases box > New database).
2. Type the database name.
3. The username is optional: if you leave it empty the database name is used.
4. Choose the site it belongs to: this way the database is included in that site's backups.
5. Press Create database.

The Database ready window opens with everything you need to connect. The password is shown only once: copy it right away (Copy button), for example into the site configuration file or a password manager. The panel does not keep it.

How to connect

The site connects to the database with these details, always visible on the database page (in Databases press Connection):

• Server (host): localhost
• Port: 3306
• Database name and user: the ones chosen at creation;
• Password: the one shown at creation (or the last one reset).

Next to each value there is the Copy button. Below you find the ready to paste examples:

• WordPress: the wp-config.php lines (DB_NAME, DB_USER, DB_PASSWORD, DB_HOST);
• PHP: the PDO connection.

When the password is not known (on the database page), the examples contain YOUR_DATABASE_PASSWORD: replace it with yours.

For security, databases accept connections only from the server itself (from the sites hosted here and from phpMyAdmin), not from the Internet.

Reset password

Lost the password? On the database page, next to the user, press Reset password: a new one is generated and shown only once, together with the updated connection details. The old one stops working immediately: remember to update it in the site configuration (for WordPress in the wp-config.php file).

With Add user you can create a second user for the same database (for example for a collaborator or another application).

phpMyAdmin

phpMyAdmin is the classic tool to view and edit tables, run SQL queries, import and export a database (for example the .sql file from an old hosting).

1. Open the database (or the Databases list, or the site's Databases box).
2. Press Open phpMyAdmin: a new tab opens and you are already in, without typing a password.

How it works, in short:

• the panel creates temporary access valid only for that database and opens it for you;
• the access expires on its own after one hour (or when you press Log out in phpMyAdmin): to continue, go back to the panel and press Open phpMyAdmin again;
• the link is valid for 60 seconds and works only once: if you copy it and open it later it does not work;
• phpMyAdmin has no login page with username and password: you get in only from the panel. Whoever opens the phpMyAdmin address directly sees an invitation to open it from the panel.

The browser may show a certificate warning the first time: phpMyAdmin uses the same certificate as the panel.

Every phpMyAdmin opening is recorded in the Log.

If the button says phpMyAdmin not installed, the server administrator must install it (command panel-agent setup phpmyadmin).

Deleting a database

Press the bin next to the database (or on its page). The database, all its data and its users are deleted.

Deletion is permanent. If the database is linked to a site, the backups already made still contain it.