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.

(more…)

October 1, 2006

Out of range value adjusted for column error

Filed under: MYSQL,PHP — Celia @ 7:23 am

This is one bug that had me smitten ever since Mysql 5 was released. If you had encountered this error and are searching in vain throughout google and msn for a fix, please do not be discouraged. This is a very simple problem and can be corrected easily.

1) Use SQL_MODE functionality:

Login to the Mysql shell and give the following command.

SET GLOBAL SQL_MODE=”;

Voila. That fixes your problem.

2) Revert to Mysql 4.

If you are not sure on how to do 1), this is the only other option avaliable.

(more…)

Create a free website or blog at WordPress.com.