Resetting mysql/mariaDB passwords.
To reset a forgotten root password on MySQL/MariaDB:
mysql --version
systemctl stop mariadb
systemctl stop mysql
mysqld_safe --skip-grant-tables --skip-networking &
mysql -u root
MariaDB [(none)]> update mysql.user set password=password('MyNewPass') where user='root';
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> exit
mysqladmin shutdown -u root -p
systemctl start mariadb
systemctl start mysql
Resetting the cacti local admin pw.
mysql -u root -p cacti
MariaDB [cacti]> update user_auth set password=md5('newpasswordhere') where username='admin';