MySQL Connection Failed: Client does not support authentication protocol requested by server

[onmcv]

when i finish new installation and click catalog i recieve the error

Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\apache\htdocs\catalog\includes\functions\database.php on line 19

Unable to connect to database server!

 

what is the problem?

[shooter-boy]

Looks like a config error with your local development environment.

 

Are you using WAMPP or something like that, or did you install everything new?

 

Rob

[Mulder]

I ran into this same error and did the following to correct...

 

1) Log in to mysql.exe

2) Type the following at the mysql prompt, where root is the db username and myoldpassword is the new pwd:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('myoldpassword')

-> WHERE Host = 'localhost' AND User = 'root';

Response you will get:

Query OK, 1 row affected (0.01 sec)

Rows matched: 1 Changed: 1 Warnings: 0

3) Type the following at a mysql prompt:

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.09 sec)

4) Type "quit" to exit.

 

More documentation:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

 

Hope this helps.

[sulek]

I ran into this same error and did the following to correct...

 

1) Log in to mysql.exe

2) Type the following at the mysql prompt, where root is the db username and myoldpassword is the new pwd:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('myoldpassword')

-> WHERE Host = 'localhost' AND User = 'root';

Response you will get:

Query OK, 1 row affected (0.01 sec)

Rows matched: 1 Changed: 1 Warnings: 0

3) Type the following at a mysql prompt:

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.09 sec)

4) Type "quit" to exit.

 

More documentation:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

 

Hope this helps.

 

 

 

Thanks Mulder,

its very useful for me...

 

Warm Regards

sulek

[RenegadeCowgirl]

I can't get this work...

UPDATE mysql.user SET PASSWORD = OLD_PASSWORD( 'xxxxxxxxxxxxx' ) WHERE Host = '10.xxx.xxx.xxx' AND User = 'xxxxxxxxxxx';

 

I'm getting the response: #1142 - UPDATE command denied to user 'xxxxxxxxxxx'@'xx.xxx.xxx.xxx' for table 'user'

 

This is a mysql 5.0 db on hosted by Godaddy... do they have something firewalled or configured that would keep me from running this update?

[RenegadeCowgirl]

I can't get this work...

UPDATE mysql.user SET PASSWORD = OLD_PASSWORD( 'xxxxxxxxxxxxx' ) WHERE Host = '10.xxx.xxx.xxx' AND User = 'xxxxxxxxxxx';

 

I'm getting the response: #1142 - UPDATE command denied to user 'xxxxxxxxxxx'@'xx.xxx.xxx.xxx' for table 'user'

 

This is a mysql 5.0 db on hosted by Godaddy... do they have something firewalled or configured that would keep me from running this update?

Okay, I found the problem that was causing this error message to occur - for me, anyway.

I didn't have the correct authoritites (777) on the config.php file. I thought I updated it, but found the updates are not "sticking".

The root cause, was that my site was hosted on a Windows server at Godaddy. I called them, and they switched me to a Linux based host, and I was able to update my permissions, and execute the install with no further problems.

 

One step down, 9,999 to go... next, determine if it's easier/better to customize the osCommerce site with my products, or add shoping cart and checkout functionality to my existing site built through Dreamweaver.