mariadb rootin salasanan palautus
salasanan voi ensisijaisesti palauttaa web ui:n servicen alta ja jos ei toimi niin:

How to reconfigure the password of root account in MariaDB


1. Go to ADM\Services\MariaDB Server to stop the MariaDB service

2. Use ssh to login into the NAS by "root" account

3. Run the mysql service without permission:
root@AS7004T# mysqld_safe --skip-grant-tables --skip-networking &

4. Login into the mysql by root
root@AS7004T#mysql -u root
Below is what you will see in the console:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.0.28-MariaDB Source distribution
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

5. Flush the privileges

6. Alter the passwords:
=> We set the pass as admin for root

MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'admin';
MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('admin');
MariaDB [(none)]> UPDATE mysql.user SET authentication_string = PASSWORD('admin') WHERE User = 'root' AND Host = 'localhost';

7. Go to ADM\Services\MariaDB to enable the MariaDB
Lisääjä: Mikko
Aika: 2020-01-14 23:40:36.
jos su: must be suid to work properly virhe tulee, katso ls -l /bin/busybox
jos oikeudet on rwxr-xr-x eikä rwsr-xr-x aja roottina chmod 4755 /bin/busybox

jos pipillä tulee unable to execute i686-asustor-linux-gnu-gcc
mene: /opt/bin ja siellä ln -s i486-openwrt-linux-gnu-gcc i686-asustor-linux-gnu-gcc

jos tulee virhe verify_pkg_installable: Only have 0kb available on filesystem /opt.....
asenna roottina opkg --force-space ....

ln -fs /usr/local/AppCentral/entware-ng/opt/ /opt
/opt -> /usr/local/AppCentral/entware-ng/opt/
Lisääjä: Mikko
Aika: 2017-11-12 14:04:00.
olut (149)