Re: Mysql upgrade problem 3.23 to 4.1

2004-12-22 Thread Gleb Paharenko
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:

Mysql upgrade problem 3.23 to 4.1

2004-12-21 Thread Jerry Swanson
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

Re: Mysql upgrade problem 3.23 to 4.1

2004-12-21 Thread Jason Joines
Jerry Swanson 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

Re: Mysql upgrade problem 3.23 to 4.1

2004-12-21 Thread valentin_nils
Hi Jerry, Did you read the documentation ? It explains that you have to upgrade the mysql database wqith the mysql_fix_privileges script. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com I upgraded mysql