Käyttäjänimi:
Salasana:
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
=>
MariaDB [(none)]> FLUSH PRIVILEGES;

6. Alter the passwords:
Example:
=> 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.
asustor
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
eli
/opt -> /usr/local/AppCentral/entware-ng/opt/
Lisääjä: Mikko
Aika: 2017-11-12 14:04:00.
olut (122)
Tyypit
Valmistajat