MariaDB quick start

The BeAdmin panel can install MariaDB on the server — a database management service — and connect it to your sites. The module exposes database, user, and access management, and more. You can also install phpMyAdmin — a graphical web interface for working with database contents.

Install the module

Open MariaDB in the side menu and click "Install". Installation takes a few minutes — the progress is shown in the logs. Once installed, the module page exposes the "Databases" and "Users" tabs. If installation fails, try running it again: another process may have prevented the package manager from completing the task.

Create a database

A database is the core entity of the module — a container in which applications keep their data. Applications work with it as users that have been granted access to the database in question. To get started, create a database.

1. On the "Databases" tab, click "Create database".
2. In the "Name" field, enter the database name. Latin letters, digits, and underscores are allowed. The panel will also warn you if you try to use a reserved word, or if the name is too long or too short.
3. Click "Create database".

The database will be created and shown in the list.

Create a user

A user is required to work with a database. As a rule, every application has one or more users it uses to talk to the database. Create a user and pick the database for them right away.

1. On the "Users" tab, click "Create user".
2. Fill in the fields:
   • "Name" — Latin letters, digits, and underscores. The panel will warn you if the name is reserved, too long, or too short.
   • "Password" — at least 8 characters, including letters, digits, and special characters. If you don't want to come up with one yourself, use the password generator button next to the field.
   • "Databases" — pick one or more databases you have created. If the list is empty, create a database via the button next to the field.
3. Click "Create user".

The user will be created and shown on the "Users" tab with the list of databases they have access to.

Install phpMyAdmin

For convenient work with the contents of databases, BeAdmin can install phpMyAdmin — a web interface for MariaDB. It requires one of the supported PHP versions, so it is installed as a separate step.

1. On the module page, in the "phpMyAdmin" block, pick the PHP version the service will run on. phpMyAdmin supports PHP 8.0 and above — any version will do. If a suitable version is not installed yet, the panel will offer to install it.
2. Click "Install".

⚠️ phpMyAdmin service database and user

The panel will automatically create a service database and a user for the service. Do not delete them — the service cannot work without them. If you do delete them, run a phpMyAdmin reinstall — that will restore the service.

After installation, the block shows a "Go to phpMyAdmin" button — it opens the web interface.

Sign in to phpMyAdmin

The "phpMyAdmin" block on the module page shows the login and the root password for the MariaDB server. Use them to sign in to phpMyAdmin and work with all databases on the server.

If you need limited access, sign in as one of the users you created. phpMyAdmin lets you sign in as any MariaDB user on the server, so you can work only with the databases that user has access to.

Useful links

• MariaDB. Managing database access
• MariaDB. Importing data into a database