MariaDB-server configuration

After installation MariaDB-Server needs configuration.

Setting root password

First step of MariaDB-Server configuration is setting root password.

Launch MariaDB-server in safe mode with command:

mysqld_safe --user=mysql 2>&1 >/dev/null &

Set root password

mysqladmin -u root password

After setting root password MariaDB-server can be stoped

mysqladmin -p shutdown

Start MariaDB-server on startup

To start MariaDB-server on system startup you have to run command:

cd /usr/share/blfs-systemd-units
make install-mysqld

Advanced MariaDB-server configuration

More information about MariaDB-server configuration you can get on MariaDB knowledge base (KB) https://mariadb.com/kb/.

The MySQL Reference off-line manual can be downloaded from https://dev.mysql.com.