Run the following commands in terminal one by one
sudo /dspace/bin/dspace stat-initial
sudo /dspace/bin/dspace stat-monthly
sudo /dspace/bin/dspace stat-general
sudo /dspace/bin/dspace stat-report-initial
sudo /dspace/bin/dspace stat-report-monthly
sudo /dspace/bin/dspace stat-report-general
Then visit dspace home page, login to your dspace, then click on Statistics tab in Administer page
Check mysql --version
MariaDB output mysql Ver 15.1 Distrib 10.4-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Stop MariaDB
sudo systemctl stop mariadb
Configuring MariaDB to Start Without Grant Tables
sudo systemctl set-environment MYSQLD_OPTS="--skip-grant-tables --skip-networking"
sudo systemctl start mariadb (ensure it started with "sudo systemctl status mariadb")
sudo mysql -u root -p
MariaDB prompt Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> (reload the grant tables by issuing the FLUSH PRIVILEGES command)
MariaDB [(none)]>FLUSH PRIVILEGES;
MariaDB [(none)]>SET PASSWORD FOR root@localhost = PASSWORD ('NEWPASSWORD');
Output Query OK, 1 row affected (0.00 sec)
