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]