Geeks With Blogs
Tim Huffam Dotting the I and crossing the T of I.T.

This seems to be quite a common error for many people installing PhpMyAdmin for the first time.

The phpmyadmin (pma) docs mention it - basically stating that the mysql client is out of date.

In the past I've solved this by updating my version php, and also by using the manual install as the windows installer package uses (well it used to) an old version of the mysql client library.

However today I discovered a simple workaround here  (thanks a million to Ram Prasad who posted it!!!!) - and what a simple solution it is!  Just run the following SQL to reset your password:

SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');

Tim

 

 

Posted on Monday, October 31, 2005 6:39 AM MySQL , PHP (incl PhpMyAdmin) | Back to top


Comments on this post: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
very nice.. worked perfectly. dont forget to replace 'password' with your correct password
Left by abdullah on Nov 24, 2005 2:00 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thanks !! :)
phew..
E
Left by E on Dec 18, 2005 7:43 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
That was me who posted it :-) thanks for linking to my article.
Left by Ram Prasad on Mar 18, 2006 10:06 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Excellent - most useful piece of online help I've seen this year.
Left by Graz on Apr 28, 2006 7:57 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Saved a life beyon a lot of time!!! Thanks.
Left by ugur on Oct 17, 2006 1:07 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Yessssss!!! thank you Tim and Ram Prasad!
Left by Joe Pellicer on Oct 21, 2006 4:24 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Don't forget to modify your pma user password, if you created the user on MySql, and have the feature enabled. I found phpMyAdmin would not start until I old_passworded that user too, just root user was not enough.
Left by bikemike on Nov 16, 2006 10:27 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
You are a GOD!
Left by Patrick on Dec 22, 2006 9:24 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
How do you get mysql command prompt in 5.0 on win 2003 server?
Left by Web Dude on Jan 16, 2007 12:59 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
THANK YOU SO MUCH! This was honestly the best..most helpful information I have found on the internet in a long while.
Left by SQL client on Jan 19, 2007 5:20 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Many thanks for your precious sugession.
Left by Monsy on Mar 19, 2007 9:09 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Nothing can be said greater :-). Thank Tim very much
Left by Tran Phong on Apr 10, 2007 4:02 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Here is the updated link the article:

http://www.megalinux.net/archives/463.html

- Ram
Left by Ram Prasad on Apr 17, 2007 9:57 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thank you, just simple, but very usefull
Left by Minimoi on Apr 30, 2007 1:26 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
ok im completely new to php and mysql and am trying to learn this

i bought a server on godaddy.com and made a mysql database

and when i try to connect, using the following code:

<?php
// Connecting, selecting database
$link = mysql_connect('theserveripaddress', 'myusername', 'mypassword')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('mydatabase') or die('Could not select database');
?>

it gives me this error:

Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client


plz tell me what my code needs to be in order for it to work.

the MySQL is version 5.0

i dont know what else to do

help plz
Left by gev on May 31, 2007 2:40 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
I have done the same thing Have you had any luck fixing this yet?
Left by Ava on Jun 17, 2007 7:12 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
This did not help in any way

I've got MySL 5 with PHP 4 on windows 2003 and the error is coming up when installing a PHP forum or trying to access phpmyadmin

PHP is fine on this machine and we have SQL 2000 as a database backend which is fine as well.

No matter what I try (read plenty of articles) I cannot get around this error. The SQL old password statement does not help!!!
Left by James on Jun 24, 2007 9:02 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Hi....Tim and Ram


Really i have no words to make cheers...
i fought with that problem for around 2 days as i am new.....but finally U Masters are solved my problem and made my confidence to high...Thanku SOOOO much...
Left by giri on Aug 04, 2007 12:31 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/indiarea/public_html/eknazar/common/config.php on line 118
can not connect to database
Left by balamurugan on Aug 14, 2007 9:09 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Bonjour,

Mes amis j'ai le même problème:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\www\projets\FirstSite\select2.php on line 6
Connection impossible .

et voici mon code source:

<?php
$host = "localhost";
$user = "nabil";
$password = "nabil";
$database = "formations";
$conn = mysql_connect($host,$user,$password);
if (!$conn) {
echo "Connection impossible\n";
exit;
}
$result = mysql_db_query("database","select * from user;");
if ($result > 0) {
while($row = mysql_fetch_array($result)) {
echo $row["nom"] . $row["prenom"] . "\n";
}
}
mysql_close();
?>




je travail sous windows, Php 5 et MySQL 5.

Vous avez une soulution?


Left by wahhouche on Aug 31, 2007 2:07 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Refer again: http://www.megalinux.net/2005/09/phpmyadmin---cl.html

you have set password for root . it should be the user who is actually running the query (user@localhost or user@server)
Left by Ram Prasad on Nov 13, 2007 7:20 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
A two year old posting that's still helping. Thanks!
Left by Dan on Dec 05, 2007 7:48 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
U R AMAZING, PERFECT, QUICK, EASY!!!!!! THANX A MILLION, U JUST SAVED ME TENS OF HOURS MORE OF DIGGING INTO THIS PROBLEM, I BLESS U.
Left by Yehuda on Dec 26, 2007 6:26 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
i got an error when i run this query.

QUERY: SET PASSWORD FOR myuser@myhostname = OLD_PASSWORD( 'mynewpassword' )

ERROR: #1044 - Access denied for user 'myuser'@'%' to database 'mysql'
Left by noister on Jan 01, 2008 12:07 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
you need to be root to launch the query.
Left by xhiena on Jan 07, 2008 11:18 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Many thanks!!!!!!!
Left by Le on Jan 17, 2008 11:46 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Warning: mysql: User unable to reach the IQ level requested by a computer: consider using Excel instead.

Joke aside: this helped me a lot with PHP4.4 & MySQL5
Thanks!
Left by toomanyfingers on Feb 13, 2008 8:22 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
I would like to know why this is happening in the first place?
Left by Earl on Feb 18, 2008 2:00 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
My grain of sand here:

If you see this problem using phpMyAdmin, and you have a Headache trying to configure "congi.inc.php" in root or config folder. After you put this useful line direct in your MYSQL "SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');" go to /libraries and configure your user and pass direct there.

:)
Left by atreju on Mar 12, 2008 4:54 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thanks. Perfect
Left by Raji on Mar 25, 2008 12:10 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thanks a bunch!!!!! Was getting ready to throw the PC out the window!!!
Left by MaryK on May 04, 2008 8:24 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
user name is 'test'
and pwd is '1234'
show this message
"Client does not support authentication protocol requested by server; consider upgrading MySQL client "

please help me.
Left by Abdullah Al Mamun on May 04, 2008 9:24 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Make sure to:
1) replace "user@localhost" with just the user name (do not append @localhost"
2) replace the text that says password with your password


SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');
Left by agallers on May 18, 2008 10:48 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thanks so much!! Worked perfectly with the extended help of agallers, above!
Left by Brian on May 22, 2008 12:41 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
I had problems with this as well, and I changed from a Windows based server to a Linux based, and everything was fixed. Usually hosting companies will allow you to change without any additional charges.
Left by Sol on May 23, 2008 5:46 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
A quick note:

After using the OLD_PASSWORD trick, you need to reload the user info with:

FLUSH PRIVILEGES;

I'm guessing that's why it isn't working for a number of you.
Left by Dave on Jun 07, 2008 7:42 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thanxs!!! Muchas Gracias!!!
Left by Jorge Batista on Jul 02, 2008 7:09 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thanks! It worked Woohoo!
Left by Ciir on Jul 10, 2008 9:10 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
SET PASSWORD FOR tannadevang = OLD_PASSWORD( 'myoldpassword' )

change myoldpassword with your password.

It worked for me, thanks a lot who posted this solution
Left by Devang Tanna on Aug 11, 2008 10:32 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thank you, saved me the headache!
Left by Vibs on Sep 03, 2008 4:36 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thanks a bilion to you Tim, it's about 2 after midnight and finaly you answer saved me :).
Left by astrit on Sep 19, 2008 12:09 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
THanks!!!!. Worked like a charm.
Left by Sree Raj. on Oct 15, 2008 8:27 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Hello

I get this same failure when trying to set up a MySQL connection using Dreamweaver MX 2004. My hosting service uses CPanel with phpMyAdmin and MySQL. I have tried using the SQL code but it doesn't seem to work.

I am a total noob when it comes to MySQL and PHP. When you say user@localhost, is that literally what I type or should I replace them with an actual username and host address? If so where do I get these from?

Sorry if this sounds stupid but I have no experience with this kind of thing, I've spent days trying to work it out and I'm literally losing my mind!

Thanks
Left by Paul on Oct 16, 2008 4:18 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Yep, that did it. Excellent.
Left by maralbjo on Nov 26, 2008 5:07 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
thank u so much
Left by mhdanas on Dec 16, 2008 1:49 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
How do I do to execute that query if I cannot access the server as root? I have a hosting account on godaddy and if I execute that query I get a message saying I do not have priviledges to modify mysql table
Left by Juan on Jan 05, 2009 11:58 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Holy CRAP! Thanks, Ram Prasad! I was going nuts trying to set up my OSCOMMERCE site when I got this error message. Now its all fixed.
Left by Ari on Jan 18, 2009 7:43 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Great !!! It is a quick fix.
Left by Avinash on Jan 18, 2009 8:54 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
I'm completely new to this, and i'm trying to set up my oscommerce thing. I did that command thing SET PASSWORD FOR user@localhost = OLD_PASSWORD('password'); , and it said Access denied... Someone above said you have to be in "root", can you please clarify that?
Left by Eric Kim on Feb 23, 2009 8:14 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thanks to agallers , and info for gev(its 2 yrs hope it has been resolved) & Eric.

For user of Godaddy.com using PHP and Mysql
getting this error

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Make sure to:
1) replace "user@localhost" with just the user name (do not append @localhost"
2) replace the text that says password with your password

so SET PASSWORD FOR user = OLD_PASSWORD('password');

IT will work.
Left by Alok on Apr 08, 2009 6:13 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
thanks buddy helped me a lot....
Left by sidhu on Apr 24, 2009 10:49 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
u r really a god...i was struggling wid this problem wid for hours....i finally found the solution here...thanks a billion
:))))))))))
Left by samve on May 06, 2009 8:14 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
where can i put that one?

do i need to include it in my codes? or just run it in phpMyAdmin
SQL...??
Left by reige on May 16, 2009 6:40 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
really great help
Thank you very much
Left by rakesh on Jun 23, 2009 3:53 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
user without '@host' worked on godaddy! Thanks a lot! (I've started learning php only an hour ago, btw!)
Left by VinGenie on Jul 02, 2009 11:18 AM

# re:Database Connection Failure--Client does not support authentication protocol requested by server; consider upgrading MySQL cl
Requesting Gravatar...
please send me the solution.
Left by falguni on Jul 10, 2009 7:33 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
OH Great works perfect
Left by Shafat on Jul 22, 2009 3:23 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
I shouldn't have tried at all. I should have came here waaayyy before. Thx a lot
Left by alex on Sep 21, 2009 2:39 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Sweet. I spend hours trying to get this to work. Go figure one line of code.
Left by Mortage_Master on Nov 09, 2009 6:45 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
I've got MySL 5 with PHP 4 on windows 2003 and the error is coming up when installing a PHP forum or trying to access phpmyadmin

Left by glb on Mar 30, 2010 8:22 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
thanks tim and ram, you guys are life saver :-)
Left by Rupesh on Jun 04, 2010 4:19 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thank You So Much
Left by Tui on Aug 04, 2010 3:52 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thankyou very much It saved lot of my time.
Left by bhargav on Aug 16, 2010 4:57 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
i am php programmer.site in godaddy.com hosting in asp.net but i usea php and mysql, error so i facing the problems like

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Left by vasant on Feb 18, 2011 1:50 AM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
Thank you...
Left by Z.dj on Mar 19, 2011 1:32 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
you are genius maaaaan, I must thank you millions of times which i did you already. That was charming. Save my life baby.
Left by bharadwaj on Apr 26, 2011 2:32 PM

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Requesting Gravatar...
god bless u sir g
m very thankfull 2 u,,,,,
Left by ra1 on Jul 06, 2012 8:34 AM

Your comment:
 (will show your gravatar)


Copyright © Tim Huffam | Powered by: GeeksWithBlogs.net