Re: Very old question: Mysql and old authentication
| From: | Mailing Lists) | Date: | Thu, 29 Oct 2009 20:33:24 +0000 |
| Subject: | Re: Very old question: Mysql and old authentication | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46599@lists.php.net to get a copy of this message | ||
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.
Andy
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 ?