[MariaDB] MariaDB+phpMyAdmin MySQL Server Fork
Posted: 22 Feb 2021, 06:44
About :
Applicable models: x.64 series
Applicable TOS4: 4.1.27 or later versions
Applicable TOS5: 5.0.130 or later versions
App download: https://tmnascommunity.eu/download/mariadb
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
Code: Select all
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)
Code: Select all
/usr/local/MariaDB/bin/MariaDB/bin/mysql_secure_installation --basedir=/raid/data/module/MariaDB/bin/MariaDBif root password was not defined:
Code: Select all
/usr/local/MariaDB/bin/MariaDB/bin/mysql_upgrade --defaults-file=/usr/local/MariaDB/bin/MariaDB/my.cnf -u rootCode: Select all
/usr/local/MariaDB/bin/MariaDB/bin/mysql_upgrade --defaults-file=/usr/local/MariaDB/bin/MariaDB/my.cnf -u root -phttps://mariadb.org
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.