SELECT CONCAT('[', passwd, ']') FROM test WHERE user='anniyan'
This will show the password currently registered for user 'anniyan'. Note that I enclose the password field contents inside square brackets, just to see if there is any annoying char somewhere. If there is no such user, you've found the bug. Then:SELECT PASSWORD('insert-your-password-here') FROM test
(I don't remember if the FROM section is needed here) This will show you what is the encrypted form of the password you're trying to use. There should be no need for brackets here, but if you're paranoid add them. If the password is not equal to the one above, you've found the bug - probably you made a typo when inserting the password. Just reset it in the database (using an UPDATE command) and you're done.
Enough guessing for the moment :)
Flavio
perl -ple'$_=reverse' <<<ti.xittelop@oivalf
Don't fool yourself.
|