If you enter a password, another dialog box will come up for you to re-enter
the password to confirm.

If you want MariaDB to start automatically after a reboot, run the following as
root

[root@server]# systemctl enable mariadb

Configuring and Using MariaDB

The configuration files are stored in the /etc and /etc/my.cnf.d directories.
If any changes are made, you must restart MariaDB for it to read the them.
This can be done by logging in as root and running:

[root@server]# systemctl restart mariadb

Main configuration file /etc/my.cnf

This is the main configuration file for MariaDB. There are a few settings you
may wish to change:

bind

The ip address that MariaDB is listening to. It can only listen to one ip
address at any time. By default it will listen to 127.0.0.1 (aka
localhost), meaning that the MariaDB service will only be accessible from
the instance it is installed on. If you want to connect to it from other
DreamCompute instances, you can change this to your instances IPv4 or IPv6
IP address. Here is what an IPv6 configured MariaDB bind variable looks
like:

bind-address = 2607:f298:6050:8a28:f816:3eff:fe62:c9c3

max_allowed_packet

The largest size allowed for a single packet, which normally is only
relevant for restoring backups. If a backup was created on a server with
a high setting for this value, it may have difficulty restoring on another
machine with a lower setting for this value. The default is 16M.

Resetting the root password

If you forget the root password, it can be reset by running this command and
entering in a new password twice.

[root@server]# /usr/bin/mysqladmin -u root password 'new-password' -p

Connecting to MariaDB with a shell

To connect to your new MariaDB install, to setup new databases or configure new
users, you can run these commands.