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

by Herman Tarigan 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

Herman Tarigan

Pernah menjadi Operator warnet, Customer Service Webhosting, System Administrator Webhosting, Website (SEO) Consultant, Operational Manager, Marketing dan sekarang memilih menjadi FREELANCE :)

Incoming search terms for the article:

client does not support authentication protocol requested by server consider upgrading mysql client, cara upgrade mysql client, Client does not support authentication protocol requested by server; consider upgrading MySQL client, Client does not support authentication protocol requested by server, client does not support authentication protocol requested by server; consider upgrading mysql client in adodb-mysql inc php on line 355
Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google
  • LinkedIn
  • Live
  • Print this article!
  • Slashdot
  • StumbleUpon
  • Technorati
  • YahooMyWeb

Tagged as: ,

{ 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