Hello.
Looks like passwords in your table are stored in old short format. Use old_password() instead of password(). See: http://dev.mysql.com/doc/mysql/en/password-hashing.html Lancer Emotion 16 <[EMAIL PROTECTED]> wrote: > Hello everbody,i have a problem with mysql and i wish you could help me. > I have this table named users : > > +----+--------+----------------------+----------+-----------+---------+--------- > + > | ID | user | pass | thegroup | firstname | surname | > enabled > | > +----+--------+----------------------+----------+-----------+---------+--------- > + > | 1 | Admin | *4ACFE3202A5FF5CF467 | 1 | Mr | Admin | 1 > | > | 2 | admin2 | *4ACFE3202A5FF5CF467 | 1 | Mr | Admin | 1 > | > +----+--------+----------------------+----------+-----------+---------+--------- > > The password in both cases are : admin . > When i do any of this querys : > > select * from users where pass=password("admin"); > select * from users where pass='admin'; > select * from users where pass="password('admin')"; > > i get an empty set, i dont know why. > When i do : > > select password('admin') > > i get : *4ACFE3202A5FF5CF467898FC58AAB1D615029441 > > Please help me. > Thanks > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
