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 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
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
Yep, is very weird, all works on Local Server
- Local Server
old_passwords OFF
version 5.1.36-community-log
- Local Php
PHP Version : 5.3.0
Before this change, we use Php 5.2.6 with no problems
-Remote Server
old_passwords ON
version 5.0.45
Chris dmag...@gmail.com wrote in message
Hi there i`got this php script that shows results when the user type letters in
a searchbox, stretching the results every time the user enters a new letter.
But i would like every result shown, to have a link to a specific html page,
how can i do that. I mean i am using a small guestbook
Chris wrote:
That's really confusing.
It works against a mysql 5.1.36 but not against a mysql version 5.0.45?
And gives you an error about trying to connect to mysql 4.1 or lower?
I have only seen this behavior when I use XAMPP on Windows and attempt
to connect to a different MySQL server
Hi there i`got this php script that shows results when the user type letters in
a searchbox, stretching the results every time the user enters a new letter.
But i would like every result shown, to have a link to a specific html page,
how can i do that. I mean i am using a small guestbook
-Remote Server
old_passwords ON
version 5.0.45
That's probably why - as I said in my previous e-mail, the mysqlng
driver doesn't support the old authentication mechanism. If you
cannot change the remote server, you need to re-compile PHP with the
MySQL client library (libmysql)