MySQL Forums :: Install :: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

New Topic

SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Posted by: Fernando Cabal ()

Date: November 07, 2005 10:46PM

Hello everyone , I lost quite sometime on this one

After upgrading to mysql 4.x , I created a database , added an user and set password and permissions.

Everytime I tried my script , I got mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Please do the following:

In /etc/my.cnf , add "old_passwords=1" to all sections (maybe only needed in the mysqld section but I did it everywhere)

stop and start the mysqld

reassing the password to the mysql user so it will be stored using the old format

Bingo!

Cheers

Fernando Cabal
http://www.interteldepot.com
(Cheap Domain Names & Hosting solutions)

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