Security Assist has not been updated to work with MySQLi. You will have to use the MySQLi Authenticate User Server behavior if you want to use MySQLi connections for a login page.
If you continue to have issues we can set up a screen sharing session to help you debug it. Just post a phone number in the private area and I can give you a call to make sure your problems get resolved.