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

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 mysql

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 mysql-

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

mysql upgrade problem

2002-02-23 Thread Egor Egorov
Marek, Friday, February 22, 2002, 7:11:06 PM, you wrote: MW> Hello all. MW> I'm using Debian 2.4.x MW> I was trying to upgrade mysql.3.22 to 23 by removing default packages and MW> after debianizeing rpm's with alien I installed them with dpkg. MW> After I did upgrade (as I assume ;-))) somewh

mysql upgrade problem

2002-02-22 Thread Marek Wysmulek
Hello all. I'm using Debian 2.4.x I was trying to upgrade mysql.3.22 to 23 by removing default packages and after debianizeing rpm's with alien I installed them with dpkg. After I did upgrade (as I assume ;-))) somewhere my.cnf file disappeared Do someone know how to properly upgrade 22 to 23