Issue with Login to Cacti

[vennerd]

Downloaded the latest version of the .exe and installed it on a brand new install of Windows Server 2016.
The install seemed to complete successfully but the MySQL service would not start. After trying a few solutions on the web I decided to uninstall the MySQL software and reinstall from a fresh copy. This worked successfully and I then followed the instructions on the Cacti website "Installing Under Windows - MySQL section".

Question: Step 8 - Does the bit about old password still need to be done?

I did go through the process but get errors when trying to run the sql command:
UPDATE mysql.user SET Password = OLD_PASSWORD('cactipwd') WHERE Host = 'localhost' AND User = 'cactiuser';
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'

On researching the error I found that the "Password" field no longer exists in the database table and it has been replaced by "authentication_string". So changing this in the command then produces a different error:
ERROR 1305 (42000): FUNCTION mysql.OLD_PASSWORD does not exist

If the old password step still needs to be done then can you help resolve the issues I am having?

[netniV]

MySQL is case sensitive when it comes to columns and tables (but not keywords).

Code: Select all

UPDATE user_auth SET password=MD5('admin') where username='admin';

[netniV]

If this relates to the actual SQL connection's username/password, then you need to follow https://dev.mysql.com/doc/refman/8.0/en ... sions.html but replace the root user with the one that you are trying to do.

[vennerd]

Apologies but made a massive mistake, after removing MySQL and reinstalling the setup was from scratch using the instructions on the Cacti website so the username and password defaulted back to the defaults and not those created as part of the v1.1.38 install. I entered the defaults, changed the password and accessed the Cacti GUI.

I guess that step 8 in the instructions on the site about old-password is no longer required in v1.1.38.