Tim Huffam

Dotting the I and crossing the T of I.T.
  Home  |   Contact  |   Syndication    |   Login
  152 Posts | 0 Stories | 2310 Comments | 653 Trackbacks

News

Archives

Post Categories

Interesting Blogs/Links

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

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

 

 

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
posted on Monday, October 31, 2005 6:39 AM

Feedback

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 12/18/2005 7:43 PM E
Thanks !! :)
phew..
E

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

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

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 10/21/2006 4:24 AM Joe Pellicer
Yessssss!!! thank you Tim and Ram Prasad!

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 11/16/2006 10:27 AM bikemike
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.

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 12/22/2006 9:24 PM Patrick
You are a GOD!

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

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

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

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 4/17/2007 9:57 AM Ram Prasad
Here is the updated link the article:

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

- Ram

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 5/31/2007 2:40 PM gev
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

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 6/24/2007 9:02 PM James
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!!!

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 8/4/2007 12:31 AM giri
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...

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 8/14/2007 9:09 AM balamurugan
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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 8/31/2007 2:07 AM wahhouche
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?




# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 11/13/2007 7:20 PM Ram Prasad
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)

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 12/5/2007 7:48 PM Dan
A two year old posting that's still helping. Thanks!

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 12/26/2007 6:26 PM Yehuda
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.

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 1/1/2008 12:07 AM noister
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'

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 1/7/2008 11:18 AM xhiena
you need to be root to launch the query.

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 1/17/2008 11:46 AM Le
Many thanks!!!!!!!

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 2/13/2008 8:22 AM toomanyfingers
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!

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 3/12/2008 4:54 AM atreju
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.

:)

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 3/25/2008 12:10 AM Raji
Thanks. Perfect

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 5/4/2008 8:24 AM MaryK
Thanks a bunch!!!!! Was getting ready to throw the PC out the window!!!

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 5/4/2008 9:24 PM Abdullah Al Mamun
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.

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 5/18/2008 10:48 AM agallers
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');

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 5/23/2008 5:46 AM Sol
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.

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 6/7/2008 7:42 AM Dave
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.

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 7/2/2008 7:09 PM Jorge Batista
Thanxs!!! Muchas Gracias!!!

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 7/10/2008 9:10 AM Ciir
Thanks! It worked Woohoo!

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 8/11/2008 10:32 AM Devang Tanna
SET PASSWORD FOR tannadevang = OLD_PASSWORD( 'myoldpassword' )

change myoldpassword with your password.

It worked for me, thanks a lot who posted this solution

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 9/3/2008 4:36 AM Vibs
Thank you, saved me the headache!

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

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 10/16/2008 4:18 AM Paul
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

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 12/16/2008 1:49 PM mhdanas
thank u so much

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 1/5/2009 11:58 PM Juan
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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 1/18/2009 7:43 AM Ari
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.

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 2/23/2009 8:14 PM Eric Kim
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?

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 4/8/2009 6:13 AM Alok
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.

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

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 5/16/2009 6:40 PM reige
where can i put that one?

do i need to include it in my codes? or just run it in phpMyAdmin
SQL...??

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 6/23/2009 3:53 AM rakesh
really great help
Thank you very much

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

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 7/22/2009 3:23 AM Shafat
OH Great works perfect

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

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 3/30/2010 8:22 AM glb
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



# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 6/4/2010 4:19 AM Rupesh
thanks tim and ram, you guys are life saver :-)

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 8/4/2010 3:52 AM Tui
Thank You So Much

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

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 2/18/2011 1:50 AM vasant
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"

# re: PHPMyAdmin - Client does not support authentication protocol requested by server; consider upgrading MySQL client 3/19/2011 1:32 PM Z.dj
Thank you...

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

Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: