Very old question: Mysql and old authentication

------=_NextPart_000_00B3_01CA5898.6F0C49B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Recently we update our Local Server to this:

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

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 ?
------=_NextPart_000_00B3_01CA5898.6F0C49B0--

Re: Very old question: Mysql and old authentication

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 ?


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

Re: Very old question: Mysql and old authentication

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

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?

--
Postgresql & php tutorials
http://www.designmagick.com/


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

Re: Very old question: Mysql and old authentication

------=_NextPart_000_0103_01CA58AC.03B715F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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" wrote in message =
news:4AEA0D20.5070809@gmail.com...
SuNcO wrote:
> Recently we update our Local Server to this:
>=20
> Apache Version : 2.2.11 =20
> PHP Version : 5.3.0 =20
> MySQL Version : 5.1.36 =20
>=20
> 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

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?

--=20
Postgresql & php tutorials
http://www.designmagick.com/

------=_NextPart_000_0103_01CA58AC.03B715F0--

Re: Very old question: Mysql and old authentication

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 then the one coming with XAMPP.
But I never bother to find out why because I had full access to MySQL
and could just create an account with the old password system.

--
John

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

Re: Very old question: Mysql and old authentication

--Apple-Mail-1--624363726
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=us-ascii;
format=flowed;
delsp=yes


>
> -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) instead of the PHP 5.3 native driver
(mysqlng.)



--Apple-Mail-1--624363726--

Re: Very old question: Mysql and old authentication

> 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 ?

The is an entry concerning this in 5.3.0 Backward Incompatible Changes
http://php.net/manual/en/migration53.incompatible.php

The new mysqlnd library necessitates the use of MySQL 4.1's newer
41-byte password format. Continued use of the old 16-byte passwords
will cause mysql_connect() and similar functions to emit the error,
"mysqlnd cannot connect to MySQL 4.1+ using old authentication."


The account you are trying to connect with is using an old password hash

Your options are limited, either
1) Compile PHP to use the libmysql library instead of mysqlnd
2) Have the password updated to use the newer hash.

Note The second option will prevent older clients connecting, including
the mysql extension (but not mysqli) if it is not using the mysqlnd
driver.


More information can be found in the MySQL manual on upgrading from v4.0
to v4.1
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-previo us-series.html
http://dev.mysql.com/doc/refman/4.1/en/old-client.html

--
Niel Archer
niel.archer (at) blueyonder.co.uk



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