Jump to content

Archived

This topic is now archived and is closed to further replies.

thehigherentity

password problem mysql

Recommended Posts

I have setup a table with a number of users
I am now trying to get a login to work but for some reason the password() function
is giving me loads of hassle.

the following is the query being sent to mysql

I have set the user name to username and the password to password just to make life realy easy

SELECT userref FROM users WHERE userid = 'username' AND userpassword = password('password')

if i change it to

SELECT userref FROM users WHERE userid = 'username' AND userpassword = '5d2e19393c'

it works fine so the problem has to be in the encryption

does anyone know of this problem and how to fix it?

I'm completly lost here

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
that explains it then i needed to make the field longer, I only set it to ten lol

userpassword VARCHAR(10) BINARY NOT NULL

thanks a lot its working fine now

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.