MariaDB

About : https://mariadb.org

Applicable models: x.64 series
Applicable TOS4: 4.1.27 or later versions
Applicable TOS5: 5.0.130 or later versions

Required packages:
apache24 > 2.4.46.1

Module WebUI for additional settings can be accesses at
http(s)://yournasip:port/modules/MariaDB/www

Include MariaDB v10.4.25.0 and phpMyAdmin v5.2.0

When you setup a connection to the database, type 127.0.0.1 instead localhost and use port 3307
DB storage in /mnt/appdata/MariaDB_DB (TOS4)
DB storage in /Volume1/MariaDB_DB (TOS5)

NOTE for first installation: don't forget to setup the root password

phpMyAdmin
user: root
passwd: no password

After root password is defined, use that password for login to phpMyAdmin

Define root password, remove anonymous login, remove test database, disable remote root login can be done via phpMyAdmin or SSH command

To do it via phpMyAdmin, login to phpMyAdmin (user root and no password), go to SQL tab and run the code below, replacin yourrootpassword with your desire password

SET PASSWORD FOR root@localhost = PASSWORD('yourrootpassword');
DELETE FROM mysql.user WHERE User='';
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
DROP DATABASE IF EXISTS test;
DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%';
FLUSH PRIVILEGES;

Edit file config.inc.php to add blowfish secret passphrase

By default, root password is empty and guests are allowed to login.
To add a root password and secure the installation or after any upgrade, run the following command in SSH:
(set again the root password, even if is the same)

/usr/local/MariaDB/bin/MariaDB/bin/mysql_secure_installation --basedir=/raid/data/module/MariaDB/bin/MariaDB

After any upgrade, run the following command in SSH:
 if root password was not defined:

/usr/local/MariaDB/bin/MariaDB/bin/mysql_upgrade --defaults-file=/usr/local/MariaDB/config/my.cnf -u root

if root password was defined

/usr/local/MariaDB/bin/MariaDB/bin/mysql_upgrade --defaults-file=/usr/local/MariaDB/config/my.cnf -u root -p

About:

MariaDB is a drop-in replacement for MySQL.

MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, Monty Program works to hire the best and brightest developers in the industry, work closely and cooperatively with the larger community of users and developers in the true spirit of Free and open source software, and release software in a manner that balances predictability with reliability.

TerraMaster Official Forum