Tim Huffam

very nice.. worked perfectly. dont forget to replace 'password' with your correct password

Thanks !! :)
phew..
E

??????????????? ??????????????????? ???????????????????(????????? power supply, mainboard)CPU 1.8GHz Gigabyte ??????

That was me who posted it :-) thanks for linking to my article.

Excellent - most useful piece of online help I've seen this year.

Saved a life beyon a lot of time!!! Thanks.

Yessssss!!! thank you Tim and Ram Prasad!

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.

You are a GOD!

How do you get mysql command prompt in 5.0 on win 2003 server?

THANK YOU SO MUCH! This was honestly the best..most helpful information I have found on the internet in a long while.

Many thanks for your precious sugession.

Nothing can be said greater :-). Thank Tim very much

Here is the updated link the article:

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

- Ram

Thank you, just simple, but very usefull

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

I have done the same thing Have you had any luck fixing this yet?

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!!!

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...

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

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?

Same problem. This doesn't work for me.

I do the SET PASSWORD FOR root@localhost = OLD_PASSWORD('mynewpwd');

and i get:

Query OK, 0 rows affected (0.02 sec)

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)

A two year old posting that's still helping. Thanks!

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.

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'

you need to be root to launch the query.

Many thanks!!!!!!!

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!

I would like to know why this is happening in the first place?

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.

:)

Thanks. Perfect

Thanks a bunch!!!!! Was getting ready to throw the PC out the window!!!

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.

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');

Thanks so much!! Worked perfectly with the extended help of agallers, above!

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.

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.

Thanxs!!! Muchas Gracias!!!

Thanks! It worked Woohoo!

SET PASSWORD FOR tannadevang = OLD_PASSWORD( 'myoldpassword' )

change myoldpassword with your password.

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

Thank you, saved me the headache!

Thanks a bilion to you Tim, it's about 2 after midnight and finaly you answer saved me :).

THanks!!!!. Worked like a charm.

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