[PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread SuNcO
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

Re: [PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread Andy Shellam (Mailing Lists)
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

Re: [PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread Chris
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

Re: [PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread SuNcO
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

[PHP-DB] Showing search results with links

2009-10-29 Thread Juan Stiller
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

Re: [PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread John Black
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

[PHP-DB] Rv: Showing search results with links ... sorry forgot to post php code

2009-10-29 Thread Juan Stiller
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

Re: [PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread Andy Shellam (Mailing Lists)
-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)