when you add a user to the tblloginServerAccounts table, you have to use a query because you can't just add a plaintext password, you have to set password = sha('password') to encrypt it.
Try this:
use peqlogindb;
INSERT INTO tblloginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress)
VALUES('acctname', sha('password'), 'email@domain.com', now(), '192.168.1.2');
LastIPAddress and LastLoginDate don't really matter, they get updated when they log in anyway.
|