Now let’s set password encoding to MD5 hash:
call TigPutDBProperty('password-encoding', 'MD5-PASSWORD');
'Query OK', means the password encoding has been successfully changed. Of course we changed the property only. All the existing passwords in the database are still in plain-text format. Therefore we expect that attempt to authenticate the user would fail:
call TigUserLoginPlainPw('test@example.com', 'test777'); +---------+ | user_id | +---------+ | NULL | +---------+ 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec)
We can fix this updating the user’s password in the database:
call TigUpdatePasswordPlainPw('test@example.com', 'test777'); Query OK, 1 row affected (0.01 sec) mysql> call TigUserLoginPlainPw('test@example.com', 'test777'); +--------------------+ | user_id | +--------------------+ | 'test@example.com' | +--------------------+ 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec)