It appears that I am locked out of the admin account for the WebUI for Cent 24.04.  I am not sure if it expired and never got changed, or if one of my coworkers changed it and now can’t remember the new password, but I need to get it reset via the CLI.  I have done some searching and have tried a couple of the different options that I have found.

UPDATE contact_password SET PASSWORD('MyNewPassword') where contact_alias='admin';

and

UPDATE contact_password SET password = PASSWORD('MyNewPassword') WHERE contact_id = (SELECT contact_id FROM contact WHERE login = 'admin');

Neither of which seems to have worked.  I have tried other variations on this as well with no luck.  The closest I seem to have gotten was with the first one, but it returns an error:

ERROR 1054 (42S22): Unknown column 'contact_passwd' in 'field list'
 

Any help would be appreciated to get this reset so I can access the WebUI and silence some annoying alarms.