MySQL Forums
Forum List  »  Install & Repo

Advanced Search
New Topic

Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Posted by: guillermo scharffenorth
Date: November 24, 2004 12:20PM

This is permanent solution. Instead of typing this "SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something');" in the command line client for every single user, do the following:


Find "my.ini" inside windows directory and insert the following lines (First line is just a comment, it can be ommited)

#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

Restart the service for the changes to take place.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
"mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
joape382
November 20, 2004 04:28AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Brian Stepanek
November 20, 2004 09:56PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
guillermo scharffenorth
November 24, 2004 12:20PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Stephen Unwin
November 24, 2004 02:23PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Stephen Unwin
November 24, 2004 02:32PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
ron
December 15, 2004 12:14PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
anthony katgert
December 30, 2005 05:40PM
Lighten up, man!
Philip Shanks
December 31, 2005 12:02AM
Re: Lighten up, man!
anthony katgert
December 31, 2005 02:28AM
Re: Lighten up, man!
Lenz Grimmer
March 29, 2006 03:12AM
Re: Lighten up, man!
Anuj Garg
March 24, 2007 02:58PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
r ruthers
April 29, 2006 07:09PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
christopher stubban
October 03, 2006 08:08AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
christopher stubban
October 03, 2006 08:06AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Peter Flynn
October 10, 2006 06:29AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Eduardo Duran
April 17, 2007 06:43PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
mikel gorge
September 10, 2008 08:27AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Werner Kirchner
February 26, 2005 04:10AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Russell Sykes
December 11, 2004 10:25PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Janto .
December 13, 2004 11:05AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
John son
April 29, 2008 11:36PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Krzysztof Kepinski
June 12, 2008 04:08AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
ron
December 15, 2004 09:43AM
SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
mglatts
January 07, 2005 12:12AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Palomares
January 30, 2005 02:18PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Carlos Bergueira
March 09, 2005 06:18AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Mark Herraghty
January 03, 2006 07:14PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
danscow
February 03, 2005 07:37PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Michael Kilpatrick
February 06, 2005 04:23PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
flamtriplets_2000
February 12, 2005 12:56PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
David Massey
February 20, 2005 09:04PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Kym Harper
September 01, 2005 05:38PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
vlad
February 24, 2005 03:15PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Regan DeDiana
April 17, 2005 04:00PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Priya Venkat
July 10, 2005 07:23AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
derek crabtree
October 28, 2005 02:53AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
je lopez
November 28, 2005 05:40PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
U Khan
February 15, 2006 05:08AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
rahul wa
May 30, 2007 12:21PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Jen Winter
February 12, 2005 10:54PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Richard Hawkes
February 28, 2005 01:46AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Riaz Ahammed
April 01, 2005 05:47AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
edrizzle
April 08, 2005 11:01PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
mike adams
April 28, 2005 06:37AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Ekincan Karalar
May 03, 2005 05:03AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Victor Henrique G. Almaraz
May 05, 2005 12:57AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Salman Awan
August 07, 2005 11:44AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Muhammad Taqveem
January 03, 2006 12:48AM
Don't forget to also...
Iain Hunneybell
January 03, 2006 07:48AM
THIS WORKED ON A MAC / OS X - THANK YOU!!
Andrea Pacor
January 17, 2006 11:49PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Budak Hadop
March 10, 2006 08:28AM
Other causes of error 1251
iDonny
March 16, 2006 10:03AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Zaphod Breeblebrox
May 16, 2006 06:37PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
spam
September 03, 2006 11:21AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Peter Flynn
October 10, 2006 06:59AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Bill Karwin
October 10, 2006 06:19PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Nicki
December 21, 2006 11:39AM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
sonny stevenson
February 08, 2007 07:38PM
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
rakhmat ichsan
March 22, 2007 03:44AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Ryasat Ali
February 18, 2005 12:39AM
Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Tim Rohrbaugh
February 23, 2005 10:49PM
SOLUTION "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Simon Orr
January 26, 2005 11:59PM
Re: SOLUTION "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Ryasat Ali
February 18, 2005 12:49AM
Re: SOLUTION "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Anthony Hook
July 29, 2005 11:25AM
Re: SOLUTION "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Hy Chanhan
January 15, 2006 05:20AM
Re: SOLUTION "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Hy Chanhan
January 15, 2006 05:27AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Vishnu Vundavalli
February 01, 2005 11:51PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Gheorghe Iuga
February 15, 2005 12:20AM
Step-by-step solution
tom tom
November 02, 2005 07:38AM
Re: Step-by-step solution
Oliver Dow
January 16, 2006 03:46PM
Re: Step-by-step solution
Hariprasad R
July 24, 2006 07:40AM
Re: Step-by-step solution
Jason Whitlow
March 28, 2006 11:18PM
Step-by-step solution!!!
tom tom
August 23, 2006 01:21PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
jeeet handa
April 28, 2006 05:38AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Adrian Perez Vales
November 23, 2004 06:38AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Adrian Perez Vales
November 24, 2004 04:14AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
guillermo scharffenorth
November 24, 2004 11:58AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Snaggs5899
November 28, 2004 06:09AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Jeremy Leipzig
November 29, 2004 08:57PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Matt Cartwright
November 30, 2004 09:14AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Marcin Paluch
December 03, 2004 06:24AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Eugene Sesonga
December 29, 2004 05:48PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
prasanth reddy
June 26, 2005 08:30AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
ed kwok
December 29, 2004 07:47PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Travis Weir
December 13, 2004 10:15AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Iain Hosking
December 17, 2004 01:54AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Malcolm Debono
January 12, 2005 05:20PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
big
December 04, 2004 08:51AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
joe flem
December 14, 2004 04:11PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
C.Y. Chen
December 15, 2004 12:14AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Janto .
December 15, 2004 07:20AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Insanedarkness
December 15, 2004 07:30PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
tribe.3
December 17, 2004 06:43PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Mark Kayser
December 20, 2004 09:39AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
NightWalker Unknown
December 23, 2004 05:55AM
Solution using MySQL Administrator
Frank De Luca
December 23, 2004 04:45PM
Re: Solution using MySQL Administrator
Chris Beaty
January 04, 2005 03:24AM
Re: Solution using MySQL Administrator
Hans Stoelting
January 06, 2005 04:12PM
Re: Solution using MySQL Administrator
David Skelton
January 15, 2005 09:47AM
Re: Solution using MySQL Administrator
Tony Julien
February 27, 2005 04:32AM
Re: Solution using MySQL Administrator
Bartosz Nowak
June 08, 2005 07:08AM
Re: Solution using MySQL Administrator
phil houlyman
December 03, 2005 01:47PM
Re: Solution using MySQL Administrator
Jeff Parrott
December 10, 2005 05:31PM
Re: Solution using MySQL Administrator
truword kapamara
June 19, 2007 01:30PM
Re: Solution using MySQL Administrator
Konstantinos Papadakis
August 07, 2007 03:15AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Jae Hammett
January 05, 2005 08:59PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
aleestevenson
January 16, 2005 08:11PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Mark Rosenthal
January 17, 2005 05:10PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
tezandbabs
January 20, 2005 09:00PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
carlturton1974
January 21, 2005 12:55PM
************Frank De Luca's Article Worked for me **********
Bob Builder
January 22, 2005 05:03AM
Re: ************Frank De Luca's Article Worked for me **********
Adegoke Aruna
February 26, 2005 01:11PM
Re: ************Frank De Luca's Article Worked for me **********
Matt EatMeMYSQL
April 03, 2007 03:47PM
Re: "Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Nelson La Rocca
January 27, 2005 06:37AM
Re: "Client does not support authentication protocol requested by server; consider upgrading MySQL client"
dELE OMOtSOHO
January 27, 2005 08:16AM
Re: "Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Adegoke Aruna
February 26, 2005 11:56AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Ramon Sosa
February 02, 2005 11:28AM
Re: "mysql_connect(): Client does not support .... ANSWER"
Pat Hayzlett
February 06, 2005 11:34PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Victor Erazo
February 18, 2005 05:28PM
Other Solution : Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Frédéric LEROY
February 20, 2005 11:47AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Lee Phillips
February 21, 2005 04:43AM
Re: "mysql_connect(): SOLVED - SOLUTION
net cruizer
March 23, 2005 02:43PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
foo
April 07, 2005 12:12AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
tom tom
November 01, 2005 05:11PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
qsayeed
April 22, 2005 07:47AM
On Linux Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Joon Kim
June 07, 2005 03:11PM
Re: "mysql_connect(): Client does not support authentication... SOLUTION LINUX
Matthew Szubrycht
August 11, 2005 08:21PM
SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Fernando Cabal
November 07, 2005 10:46PM
SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Fernando Cabal
November 07, 2005 10:55PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Myke Stubbs
November 28, 2005 01:56PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
A T
December 26, 2005 08:00PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Rodrigo Palmeiro
January 11, 2006 01:05AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
jonathan avrancsev
March 07, 2006 04:08PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Labidur Rahman
January 24, 2006 03:23AM
SOLUTION: Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Theophilus Kotey
January 26, 2006 05:46AM
EASY SOLUTION ! : Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Michael Kachel
February 17, 2006 10:02AM
My Solution to "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
David Mills
February 18, 2006 02:22AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Mags Ingval
March 09, 2006 10:17PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
rcolumb
May 26, 2006 05:55PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; --> libmysql.dll
robert fritz
September 13, 2006 04:11AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Terry James
October 08, 2006 10:26AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Bill Karwin
October 09, 2006 01:31PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
khalid jack
October 14, 2006 12:18AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
brendan
October 30, 2006 11:50PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
brendan
October 31, 2006 03:20PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
jiten solanki
March 08, 2007 03:46AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Marco Cuvero
May 30, 2008 07:56AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Sriram Sampath
July 31, 2008 09:53AM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
molchun molchun
August 04, 2008 02:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.