login / passwd problem

[clubcosmic]

hi all,

i have the same login script running on 2 different databases (pw servers). The login script executes fine on one but all of a sudden the very same script and table wont run on the other. I think it has to do with the password won't authenticate on the disabled one.

i thought perhaps the table was corrupt so i created a new one and still. i also copied the good script and modified to login and it still wont work.

could it be the collation? any ideas?

tnx
c.c. :confused:

[B&T]

Since you have not [rovided any information to help you, I can only guess. If it works on one server and not the other I suspect it is a file path issue- maybe coded for one of them?

[clubcosmic]

the script works if i omit the the password.

WHERE password=PASSWORD('$var')

and just connect using the username withought a password. So i think that the password is not mathing the password in the db and it is encrypted.

I'm sure it's at the mysql table level where the passwords just dont match. plus all the tables are latin1_swedish_ci

Can a password be translated correctly if latin1_swedish_ci?