We can now test user authentication:
call TigUserLoginPlainPw('test@example.com', 'test77');
If authentication was successful the result looks like this:
+--------------------+ | user_id | +--------------------+ | 'test@example.com' | +--------------------+ 1 row in set (0.01 sec) Query OK, 0 rows affected (0.01 sec)
If authentication was unsuccessful the result looks like this:
+---------+ | user_id | +---------+ | NULL | +---------+ 1 row in set (0.01 sec) Query OK, 0 rows affected (0.01 sec)