thehigherentity Posted June 16, 2006 Share Posted June 16, 2006 I have setup a table with a number of usersI am now trying to get a login to work but for some reason the password() functionis giving me loads of hassle.the following is the query being sent to mysqlI have set the user name to username and the password to password just to make life realy easySELECT userref FROM users WHERE userid = 'username' AND userpassword = password('password')if i change it toSELECT userref FROM users WHERE userid = 'username' AND userpassword = '5d2e19393c'it works fine so the problem has to be in the encryptiondoes anyone know of this problem and how to fix it?I'm completly lost here Quote Link to comment Share on other sites More sharing options...
joquius Posted June 16, 2006 Share Posted June 16, 2006 what is the length of the password field in the db? it looks like it's too short AFAIK password() is 41 byte (in mysql 4.1+) and yours is 10 chars Quote Link to comment Share on other sites More sharing options...
thehigherentity Posted June 16, 2006 Author Share Posted June 16, 2006 that explains it then i needed to make the field longer, I only set it to ten loluserpassword VARCHAR(10) BINARY NOT NULLthanks a lot its working fine now Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.