A database is a structured system for storing information that allows quick and efficient access to data. It organizes information into tables, allowing you to find each entry easily and accurately.
WordPress uses this structure to manage all content on your website; such as posts, pages, comments and more. It also stores essential information about your site's users and other various settings. Our servers run on the latest stable version of MariaDB (version 11+)
MariaDB Server is an open-source relational database with a SQL interface for data management. Originally designed as a replacement for MySQL, MariaDB now offers additional features such as support for GIS (geographic information systems) and JSON. This database is known for its speed, scalability and robustness. With an extensive ecosystem of storage engines, plugins and tools, MariaDB is versatile.
Create a database
To store and manage data, you must first create a database.
If you have installed WordPress, a new database is automatically created and linked to your site. In that case, you can skip these steps...:
Click the Add Database button at the top right of the page.
Enter the desired database name.
Optionally, you can create additional users, set permissions, or skip this step.
Click Add, and the database is created.
Edit database
To access your database, go back to the main page, select the database you want and click the PhpmyAdmin button.
Accessing your database is recommended only if you are sure of what you are doing. Wrong settings can damage your Web site or company data.
Import SQL bestand
You can import a SQL file directly into the database, which is useful when you have migrated your Web site. The file must be in a compressed format (.gz or .zip) or an uncompressed .sql file, and the file size must be no more than 500 MB.
Click the upload button.
Browse your files and select the file you want. Then click upload.
Export SQL bestand
In the same way as importing, you can export the database to save all its data. The export is downloaded as a .sql.gz file. Although not strictly necessary, it is recommended that you periodically download a backup of your database. This ensures that you have a reliable backup and recovery option in case of data loss or corruption, which is essential for protecting your information.
Click the Download button to export a .sql.gz file of your database.
Database users
Database users can work with data, and their access rights differ based on their roles and tasks. As the database owner, you can set these rights. This includes giving permission to create, add or delete data.
Add a user
Click add user in the upper right corner.
Enter the username and password for the new user.
At the bottom of the form you will find the database access section. Here you can set the rights and permissions for the user.
You can assign these rights to a specific database and define roles by disabling All database privileges, or you can simply assign all privileges as needed.
Click the add button when you're done.
Change or edit rights
Switch to the Users tab.
Click on the user you want to delete or edit.
Find the user in the Database Users section and click on the three vertical dots on the right side of the row.
Choose edit permissions from the drop-down menu or revoke access. OR
Disable all database privileges and select only the specific permissions you want to grant the user.
Delete database or users
if you wish to delete a database or users you can do simply so by clicking on the desired user or db and then scroll to the bottom of the page - then click Delete
Note that this action is inreversible and once deleted, all data is lost.