Hello.
The password hashing mechanism was updated in MySQL 4.1 to provide better security and to reduce the risk of passwords being intercepted. Use OLD_PASSWORD() instead of PASSWORD. See: http://dev.mysql.com/doc/mysql/en/Password_hashing.html Jerry Swanson <[EMAIL PROTECTED]> wrote: > I upgraded mysql mysql-3.23.58-1 to mysql4.1 > > In mysql-3.23 ( I have this field) > password | varbinary(45) | YES | | NULL > | > > I inserted data into this field as password('pass'). > > I have php script that checks if login valid. mysql-3.23 and > mysql-4.1 have identical data. > > It worked on mysql-3.23 but doesn't work on mysql4.1. Password don't match. > > Any ideas why? > -- 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]
