The mysqlnd driver doesn't support MySQL 4.1 or earlier - it looks like the server that you think is 5.0.45 is actually a lot older, or your user account on MySQL has been set up using the old authentication method.

The solution would be to re-compile PHP 5.3 with the original MySQL client library (libmysql) instead of the newer mysqlnd.


On 29 October2009, at 20:05, SuNcO wrote:

Recently we update our Local Server to this:

Apache Version : 2.2.11
PHP Version : 5.3.0
MySQL Version : 5.1.36

All works fine locally, but when we want to connect to a Remote Mysql Server 5.0.45 just can't, we got the "mysqlnd cannot connect to MySQL 4.1+ using old authentication" msg

The solution as i see is to use the OLD_PASSWORD trick, but in this case we can't do that because the Server is a Shared server and yada yada yada.. change some in the Remote Mysql Server is not an option

I think Php must provide a solution for this but we can't found it

We use SqlYog 6.05 to connect to Mysql Server's. Why it works with NEW and OLD algorithm and Php don't ?

Any help on this please ?

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to