Re: Mysql upgrade problem 3.23 to 4.1

[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:

 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]

Mysql upgrade problem 3.23 to 4.1

[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 data.

It worked on mysql-3.23 but doesn't work on mysql4.1. Password don't match.

Any ideas why?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql upgrade problem 3.23 to 4.1

[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
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?
password('pass') generates different values in 3.23 and 4.1.
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql upgrade problem 3.23 to 4.1

[valentin_nils]

Hi Jerry,
(B
(B
(BDid you read the documentation ?
(B
(BIt explains that you have to upgrade the mysql database wqith the
(Bmysql_fix_privileges script.
(B
(B
(BBest regards
(B
(BNils Valentin
(BTokyo / Japan
(B
(Bhttp://www.be-known-online.com
(B
(B
(B
(B I upgraded mysql  mysql-3.23.58-1  to  mysql4.1
(B
(B In mysql-3.23 ( I have this field)
(B password  | varbinary(45)   | YES  | | NULL
(B |
(B
(B I inserted data into this field as password('pass').
(B
(B I have php script that checks if login valid.  mysql-3.23 and
(B mysql-4.1 have identical data.
(B
(B It worked on mysql-3.23 but doesn't work on mysql4.1. Password don't
(B match.
(B
(B Any ideas why?
(B
(B --
(B MySQL General Mailing List
(B For list archives: http://lists.mysql.com/mysql
(B To unsubscribe:
(B http://lists.mysql.com/[EMAIL PROTECTED]
(B
(B
(B
(B
(B-- 
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]