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 Link to comment https://forums.phpfreaks.com/topic/12120-password-problem-mysql/ 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 Link to comment https://forums.phpfreaks.com/topic/12120-password-problem-mysql/#findComment-46190 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 Link to comment https://forums.phpfreaks.com/topic/12120-password-problem-mysql/#findComment-46480 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.