Problem
How to extend the user password when expired.
Solution
To extend the password of the admin user for 3 months, for example, use the following command (MYSQL):
UPDATE TB_USER SET `PASSWORD_CHANGE_DATE` = DATE_ADD(`PASSWORD_CHANGE_DATE`, INTERVAL 3 MONTH);
To check the expiry date of all the users
Select PASSWORD_CHANGE_DATE, USER_NAME from TB_USER;
In general:
FOR ORACLE
update TB_USER set PASSWORD_CHANGE_DATE=sysdate+90;
in days, here 90 days.
COMMIT
FOR MYSQL
update TB_USER set PASSWORD_CHANGE_DATE=sysdate()+3000;
in seconds for a couple of hours
COMMIT