Mysql Error : Client does not support authentication protocol requested by server

by Perk1z on November 25, 2007

Error :
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/path/public_html/includes//adodb-mysql.inc.php on line 355

Info :
dbuser=dbuser
dbpasswd=mypassword

Solution : Update your mysql user

mysql> UPDATE mysql.user SET password = OLD_PASSWORD(‘mypassword’) WHERE user=’dbuser’ AND host=’localhost’;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> quit

Reference :
Google Search

Incoming search terms for the article:

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google
  • LinkedIn
  • Live
  • Print this article!
  • Slashdot
  • StumbleUpon
  • Technorati
  • YahooMyWeb

Related Posts

{ 2 comments… read them below or add one }

bartcatapult February 5, 2008 at 12:08 pm

Thanks info nya..tapi permasalahan ini timbul karena apa ya?

Reply

Perk1z February 8, 2008 at 4:21 pm

Biasanya karena downgrade/upgrade mysql

Reply

Leave a Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word