SmartFAQ is developed by The SmartFactory (, a division of InBox Solutions (

"Client does not support authentication protocol requested
by server; consider upgrading MySQL client" Why?
MySQL 4.1 upwards uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients, including PHP 4 (and thus current versions of Xoops). If you upgrade your MySQL Server to 4.1, attempts to connect to it with an older PHP client may fail with the above error message.

To solve this problem, you should ideally tell MySQL to use it's old 16-bit plain text password protection rather than it's new 48-bit MD5 hash value encryption. The easiest way to do that is firstly by opening a MySQL DOS shell and type the following at the mysql> prompt....

'some_user'@'some_host' OLD_PASSWORD('newpwd');

So for example, 'some user' could be 'root'@'localhost'. Substitute the password you want to use for 'newpwd' in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.

The mysqli extension (stands for "MySQL, Improved"; new in PHP 5) is compatible with the improved password hashing employed in MySQL 4.1 and higher, and no special configuration of MySQL need be done in order to use this newer MySQL client library for PHP.

For more information see the MySQL web site : here

The comments are owned by the author. We aren't responsible for their content.


Who's Online

113 user(s) are online (2 user(s) are browsing XOOPS FAQ)

Members: 0

Guests: 113



Goal: $100.00
Due Date: Feb 28
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Did you know ?

Some modules don't work properly, if run on a PHP5 platform with the register_long_arrays directive turned off

Random question

How do I access a module's configuration settings?