A web developer’s diary

October 31, 2006

Client does not support authentication protocol;

Filed under: MYSQL — Celia @ 8:58 am

You just bought a nice piece of web software, uploaded it to your site, did some advertising, got some good users, and every thing looks so nice and rosy.

And one fine day, you decide to do upgrade your Mysql and oops, your web application stops working and reports this error.

Warning: mysql_pconnect() [function.mysql-pconnect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client.

I know. It is really irritating to see errors like this. But this is a very simple issue and can be corrected easily. This happens because, Mysql 5 suddenly decided to use a different password hashing algorithm that is incompatible with older clients.

So, what is the remedy? You can choose any one of the following options.

1) Upgrade all your client programs.
2) If you have a mysql account which still has older type password, use that account.
3) Try out this simple command.

SET PASSWORD FOR ‘some_user’@’some_host’ = OLD_PASSWORD(‘newpwd’);

4) Start mysqld with the –old-passwords option.

More details are available here.

Advertisements

2 Comments »

  1. Very useful article, it helped me get the WebCalendar application (http://www.k5n.us/webcalendar.php) working. Thanks a lot!

    Comment by Sean Hodges — December 3, 2007 @ 4:00 pm | Reply

  2. Thank you very much for sharing this! It has solved this issue for me! Cheers!

    Comment by Mike — July 18, 2008 @ 5:36 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: