RE: MySQL 4.1 and MyCC

[Paul DuBois]

At 17:25 -0500 6/11/03, Christensen, Dave wrote:
Tried this and it didn't make any difference.  Still getting the error when
I try to connect to the server with MyCC.  I CAN connect using the command
line mysql program.
Are you using the 4.0 mysql or the 4.1 mysql?

Are you trying to connect (with MySQLCC) to an account that has
a short password or a long one?

-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 5:08 PM
To: Peter Burden
Cc: Christensen, Dave; '[EMAIL PROTECTED]'
Subject: Re: MySQL 4.1 and MyCC
At 23:18 +0100 6/11/03, Peter Burden wrote:
Paul DuBois wrote:

At 11:55 -0500 6/11/03, Christensen, Dave wrote:

I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an
error when I try to connect using MyCC.  The error is   ERROR 1249:
Client
does not support authentification protocol requested by server.
Consider upgrading MySQL client.  I've tried to find a solution on
the website, but either it's not mentioned there or my search skills
need some refinement (probably the latter :-)
Anyone have any idea what I have to do to solve this one?


Start the server with the --old-passwords option.

Or put this in an option file:

[mysqld]
old-passwords


Thanks - that also answers an earlier post of mine - although I think
it should be "old-password" and if you've (as I did) set up 4.1 with
"new" style passwords, you can't then just drop this into /etc/my.cnf
without also changing all the passwords - the new and old schemes
encrypt in a different way AFAIK.
Actually, the option *is* "--old-passwords" (with an "s"), though probably
the option processor will recognize both.
Also, if you have set up 4.1 accounts with new passwords, you can still
connect to those accounts, even with --old-passwords, but only when using
4.1 clients.



That'll force the server to use the older password authentication
mechanism.
David Christensen
Brokers International, Ltd.
1200 E Main St
PO Box 160
Panora, IA  50216
(800) 362-1097 or (641) 755-2775
 >>>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

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