Success!!!! I got it working after changing my password using this command:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('mypass');
Afterwards I was able to log in via a DOS prompt. I then re-ran the PN
install and it installed like it should.
Thanks for that link and the help Paul.
-----Original Message-----
From: Marvin Cummings [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 21, 2004 8:03 PM
To: 'Paul DuBois'
Cc: [EMAIL PROTECTED]
Subject: RE: [WDG] Client doesn't support authentication protocol error
inMySQL
Cool and thanks for the update. In trying to configure my server to use old
passwords I'm having a problem with one of the commands listed on the site:
This command works fine.
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('mypass');
I get an error after attempting to issue this command:
mysql> UPDATE user SET Password = OLD_PASSWORD('mypass')
-> WHERE Host = 'some_host' AND User = 'some_user';
I get the following error:
Error 1064 (3D000): No database selected
I don't see mention to select a database here. Am I possibly using the wrong
commands?
Thanks
-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 21, 2004 7:43 PM
To: Marvin Cummings; [EMAIL PROTECTED]
Subject: RE: [WDG] Client doesn't support authentication protocol error
inMySQL
At 19:29 -0500 3/21/04, Marvin Cummings wrote:
>Then again according to the MySQL website:
>The Windows download contains both the Standard and Max server binaries. It
>also contains a version of the command-line client which uses the Cygwin
>library to provide command history and editing.
>Would someone happen to know if there are any client libraries that need
>updating on mysql 5.0?
Sounds like PHP itself needs to have its MySQL client libraries updated.
EIther that or you'll need to run your 5.0 server with --old-passwords.
By the way...
I'm removing the extra To: addresses because the cause bounces for anyone
who replies to your message from [EMAIL PROTECTED] who isn't subscribed
to those other lists.
>
>Thanks
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
>Marvin Cummings
>Sent: Sunday, March 21, 2004 7:18 PM
>To: [EMAIL PROTECTED]
>Subject: RE: [WDG] Client doesn't support authentication protocol error
>inMySQL
>
>Nope I didn't compile PHP using the client libraries or validate the
install
>using a later version of MySQL. Once I managed to get it, 5.0, working I
>went strait to the PHP install without thinking about any of this. Lemme
see
>if I can do this without installing a later version of MySQL.
>
>Thanks
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
>Hassan Schroeder
>Sent: Sunday, March 21, 2004 7:00 PM
>To: [EMAIL PROTECTED]
>Subject: Re: [WDG] Client doesn't support authentication protocol error
>inMySQL
>
>Marvin Cummings wrote:
>
>> Wondering if anyone running MySQL 5 has come across the following error:
>>
>> Error (1250) : Client does not support authentication protocol requested
>> by server; consider upgrading MySQL client
>>
>> I get this error after attempting to install PN on a Windows 2003 web
>> server. I've already created the database and granted the root user
>> account permissions to it. I'm not sure if there's anything else I need
>> to upgrade MySQL to.
>
>Well, I'm not running MySQL 5 yet, even in test, but the error
>message seems pretty straightforward. Did you compile PHP using
>the MySQL 5 client libraries?
>
>Or, have you tried this using a "production" (4.0.x) version of
>MySQL as a first step to validate the install?
>
>--
>Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
>Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
>
> dream. code.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
