Re: [PHP] MySql connection error on win XP for script that works on Freebsd 5.3

2005-10-26 Thread Vizion
On Wednesday 26 October 2005 08:35,  the author Jay Blanchard contributed to 
the dialogue on-
 RE: [PHP] MySql connection error on win XP for script that works  on Freebsd 
5.3: 

>[snip]
>I have searched the mysql website and located an article which shows
>reference
>to this error indicating that the client may need to be upgraded but as I am
>
>using the mysql-5.0.13-rc-win32.zip package I am cautious about assuming
>that
>that is the actual cause.
>[/snip]
>
>http://us3.php.net/mysqli
>
>"The mysqli extension allows you to access the functionality provided by
>MySQL 4.1 and above."
Thanks for that -- I have decided to upgrade to 5.0.5 -
I did see that file before posting but I think I must have got the wrong 
impression on first read

thanks again

david
-- 
40 yrs navigating and computing in blue waters.
English Owner & Captain of British Registered 60' bluewater Ketch S/V Taurus.
 Currently in San Diego, CA. Sailing bound for Europe via Panama Canal after 
completing engineroom refit.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] MySql connection error on win XP for script that works on Freebsd 5.3

2005-10-26 Thread Jay Blanchard
[snip]
I have searched the mysql website and located an article which shows
reference 
to this error indicating that the client may need to be upgraded but as I am

using the mysql-5.0.13-rc-win32.zip package I am cautious about assuming
that 
that is the actual cause.
[/snip]

http://us3.php.net/mysqli

"The mysqli extension allows you to access the functionality provided by
MySQL 4.1 and above."

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] MySql connection error on win XP for script that works on Freebsd 5.3

2005-10-26 Thread Vizion
I have just installed MySql on Win XP and am attempting to run a php script to 
create some databases. The script works fine on FreeBSD 5.3 running 
mysql-client-5.0.11 and mysql-server-5.0.11.

MySQL has been installed on windows XP using a download of 
mysql-5.0.13-rc-win32.zip. Test.php reports php version 4.3.1.0 and is 
installed with ZendStudio which I am currently testing on win XP as I cannot 
yet  get any version of Zend later than 3.x to run on FreeBSD.

The username for mysql is 10 chars with a password of 8 chars and is able to 
login successfully from the command line.

However when attempting to login via the script I get the following error:

"Error while connecting to MySQL: Client does not support authentication 
protocol requested by server; consider upgrading MySQL client."

I have searched the mysql website and located an article which shows reference 
to this error indicating that the client may need to be upgraded but as I am 
using the mysql-5.0.13-rc-win32.zip package I am cautious about assuming that 
that is the actual cause.

I am curious whether it is something to do with the php version.

Does anyone know how I can fix this?

Please ask for additional information you think might be helpful
Thanks in advance

david


-- 
40 yrs navigating and computing in blue waters.
English Owner & Captain of British Registered 60' bluewater Ketch S/V Taurus.
 Currently in San Diego, CA. Sailing bound for Europe via Panama Canal after 
completing engineroom refit.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php