Log into the server as root:

Log into mysql with the root user and password:

# mysql -uroot -u

Change to the cacti database:

mysql > USE cacti;

Change the password:

mysql > update user_auth set password=MD5(‘NEWPASSWORD’) where username=’admin’;