I can't login with admin in ocs inventory anymore. I've changed the password a few month ago and now...I forget it! So I went to the server and tried the following:
1. Stop the MariaDB-Server via sudo service mysql stop
sudo mysqld_safe --skip-grant-tables &
to Login on MySQL-Server I used
4. I changed to the ocs database with use ocsweb;
5. Then I updated the password:
update operators set PASSWD=PASSWORD('MyNewPasswd') where FIRSTNAME='admin';
The command select * from operators where FIRSTNAME='admin'; shows that everything's fine.
I quit the mysql server, started it via sudo service mysql restart and also restarted apache2.
If I try now to login with admin at the web interface I get the error above.
Actually I use OCS 2.4.