[MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Discussion on apps, protocols, APIs, specifications, and more. You are welcome to join us as a TOS app developer!
Post Reply
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

[MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Post by outkastm »

Image

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/MariaDB
After any upgrade, run the following command in SSH:
 if 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 root
if root password was defined[/color]

Code: Select all

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

https://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.
Attachments
2021-03-30 23_01_29-Desktop - TOS.jpg
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB][10.4.17.1]MariaDB MySQL Server Fork

Post by outkastm »

updated to 10.4.17.1
User avatar
pedfuego
Posts: 5
Joined: 03 Oct 2021, 01:58

Re: [MariaDB][10.4.17.1]MariaDB MySQL Server Fork

Post by pedfuego »

I am trying to install the latest version of MariaDB package, but there is a "no access" error.
My NAS is F2-221 and my TOS version 4.2.15.
I also tried with MariaDB 10.4.17.0 packager, but there is an error and it doesn't finish the installation.
Thanks for your work
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB][10.4.17.1]MariaDB MySQL Server Fork

Post by outkastm »

I have to adapt something to get access to app WebbUI and will do the upgrade to latest MariaDb version.
You can try to access via http://yournasip:52000 by then
User avatar
pedfuego
Posts: 5
Joined: 03 Oct 2021, 01:58

Re: [MariaDB][10.4.17.1]MariaDB MySQL Server Fork

Post by pedfuego »

It doesn't work with http://192.168.1.187:52000: ERR_CONNECTION_REFUSED
Can I test anything else?
Attachments
No 52000 port open
No 52000 port open
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB][10.4.17.1]MariaDB MySQL Server Fork

Post by outkastm »

I suppose you have also the latest apache24 installed?
This evening I will update MariaDB to latest version and will fix the permissions for WebUI (current one is not compatible with all systems)
User avatar
pedfuego
Posts: 5
Joined: 03 Oct 2021, 01:58

Re: [MariaDB][10.4.17.1]MariaDB MySQL Server Fork

Post by pedfuego »

Yes I have, and it's working.
User avatar
outkastm
Posts: 1185
Joined: 29 Dec 2020, 23:52

Re: [MariaDB][10.4.21.0]MariaDB MySQL Server Fork

Post by outkastm »

up to 10.4.21.0
User avatar
sanctimon
Posts: 98
Joined: 14 Nov 2021, 06:57

Re: [MariaDB][10.4.22.0]MariaDB+phpMyAdmin MySQL Server Fork

Post by sanctimon »

What is the location of my.cnf for this installation?
Post Reply