Default Password for Cacti not working

[ottsm]

Ok, I installed cacti on my Raspberry pi 3 B+ with raspbian installed. I used the ADD/REMOVE Software versus using the command line. I had never setup mysql before and when I looked at the /etc/mysql/dabian.cnf file it has root as the user and nothing that shows up as the password (I'm assuming it's not hidden somehow). When going to /ipaddress/cacti it went directly to the user/password, I tried admin/admin and root/<blank> and all other combinations including my pi password and other user names I setup in apache2 but I cant get in. Any ideas anyone?

[ottsm]

Figured it out from the following;
https://www.cacti.net/downloads/docs/html/faq.html

Had to do the following;

Code: Select all

sudo mysql -u root -p cacti

Then the following;

Code: Select all

update user_auth set password=md5('admin') where username='admin';

[W. H. Heydt]

Code: Select all

sudo mysql -u root -p cacti

"sudo" is superfluous. You are explicitly telling mysql to use user root.

[fbe]

"sudo" is needed if you have an unmodified MariaDB installation. "-u root -p" is not needed in this case.