Bug #4305 upgrading from 4.0.20 to 4.1.2 on OSX: cant recoonect

• Submitted: 27 Jun 2004 22:26
• Modified: 27 Jun 2004 22:54
• Reporter: gian enrico conti
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.1.2
• OS: MacOS (OSX 10.3.2)
• CPU Architecture: Any

[27 Jun 2004 22:26] gian enrico conti

Description:
I installed 4.0.20 and everything isd nice.

I can connect via PHP and/or via C calls.

I upgraded to 4.1.2.

Ok, dirs are changed and backupped in "*.bak".

I CAN login in mysql and use mysqladmin via console, but I CANNOT login any more.
PHP says error... cannot connect

"C" calls says : error 1251; "Failed to connect to database: Error: Client does not support authentication 
protocol requested by server; consider upgrading MySQL client"

and CocoamySQL cannot connect..

ANY idea?

How to repeat:
install 4.12 on osx.

[27 Jun 2004 22:54] MySQL Verification Team

Please read the below Manual chapter for to resolve this issue:

http://dev.mysql.com/doc/mysql/en/Old_client.html

[28 Jun 2004 18:51] gian enrico conti

Miguel Solorzano was RIGHT.

but the BIG problem on OSX remains.

a) PHP (the latst, too) DOES not work.
b) "C" libraries and samples does NOT work.
c)  CocoaMYSQL does NOTwork.

so SOME WORKAROUND for people with the same problem:

1) backup with sqldump
2) install mysql4.2.1
3) FIX password as in "http://dev.mysql.com/doc/mysql/en/Old_client.html", in particular 
use:

update mysql.user set password =OLD_PASSWORD('old psw') where user ='userxx';

 Start mysqld with the --old-passwords option:

./bin/safe_mysqld --user=mysql  --old-passwords  &

or create a startup Item:

#!/bin/sh
#
# (c) 2004 ing. conti
# Written by ing. conti <[e-mail]>
#
. /etc/rc.common
usr/local/mysql/bin/safe_mysqld --user=mysql  --old-passwords  &

if ANYONE wants a .sitx file with daemon, let me know.
ingconti att ing conti dot com