mysqlnd cannot connect to MySQL 4.1+ using old authentication

[Goran Juric]

Hi,

I have been running phpunit tests on PHP 5.3 (on Mac OSX 10.6) and I am getting an error:

Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using old authentication

I am using the Zends PDO_MYSQL adapter and the MySQL server is running version 5.0.86.

Everything works fine on versions prior to PHP 5.3 (because there is no mysqlnd :) ).

How to fix this?

Regards,

Goran Juric
http://gogs.info/

[Karol Grecki]

Update your mysql passwords to a new format or don't use the new mysqlnd driver available since 5.3
(it has nothing to do with ZF)

Cheers

Goran Juric wrote:

Hi,

I have been running phpunit tests on PHP 5.3 (on Mac OSX 10.6) and I am getting an error:

Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using old authentication

I am using the Zends PDO_MYSQL adapter and the MySQL server is running version 5.0.86.

Everything works fine on versions prior to PHP 5.3 (because there is no mysqlnd :) ).

How to fix this?

Regards,

Goran Juric
http://gogs.info/

[Johannes Schill]

I got the same error when i upgraded to Snow leopard (OSX 10.6). Unfortunately I haven't managed to fix this in a good way, I installed XAMPP (http://www.apachefriends.org/en/xampp.html) to get my environment back up running until i find a better solution.

This problem is not Zend Framework-related.

Cheers,

Johannes

2009/11/3 Goran Juric <[hidden email]>

Hi,

I have been running phpunit tests on PHP 5.3 (on Mac OSX 10.6) and I am
getting an error:

Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2000] mysqlnd cannot connect to
MySQL 4.1+ using old authentication

I am using the Zends PDO_MYSQL adapter and the MySQL server is running
version 5.0.86.

Everything works fine on versions prior to PHP 5.3 (because there is no
mysqlnd :) ).

How to fix this?

Regards,

Goran Juric
http://gogs.info/
--
View this message in context: http://old.nabble.com/mysqlnd-cannot-connect-to-MySQL-4.1%2B-using-old-authentication-tp26160077p26160077.html
Sent from the Zend Framework mailing list archive at Nabble.com.

[Karol Grecki]

AFAIK all you need is reset your existing password to a new format.
This happened because you upgraded your mysql server to 5.x and passwords are in 4.x format.
This should be trivial to resolve, unless your database is also accessed by some outdated clients not supporting the new format.

Cheers

Johannes Schill wrote:

I got the same error when i upgraded to Snow leopard (OSX 10.6).
Unfortunately I haven't managed to fix this in a good way, I installed XAMPP
(http://www.apachefriends.org/en/xampp.html) to get my environment back up
running until i find a better solution.

This problem is not Zend Framework-related.

Cheers,
Johannes

2009/11/3 Goran Juric <[e-mail]>

>
> Hi,
>
> I have been running phpunit tests on PHP 5.3 (on Mac OSX 10.6) and I am
> getting an error:
>
> Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2000] mysqlnd cannot connect to
> MySQL 4.1+ using old authentication
>
> I am using the Zends PDO_MYSQL adapter and the MySQL server is running
> version 5.0.86.
>
> Everything works fine on versions prior to PHP 5.3 (because there is no
> mysqlnd :) ).
>
> How to fix this?
>
> Regards,
>
> Goran Juric
> http://gogs.info/
> --
> View this message in context:
> http://old.nabble.com/mysqlnd-cannot-connect-to-MySQL-4.1%2B-using-old-authentication-tp26160077p26160077.html
> Sent from the Zend Framework mailing list archive at Nabble.com.
>
>

[Johannes Schill]

I suppose this is not the whole truth since the server is running Mysql 4.1.

Cheers,

Johannes

2009/11/4 Karol Grecki <[hidden email]>

AFAIK all you need is reset your existing password to a new format.
This happened because you upgraded your mysql server to 5.x and passwords
are in 4.x format.
This should be trivial to resolve, unless your database is also accessed by
some outdated clients not supporting the new format.

Cheers

Johannes Schill wrote:
>
> I got the same error when i upgraded to Snow leopard (OSX 10.6).
> Unfortunately I haven't managed to fix this in a good way, I installed
> XAMPP
> (http://www.apachefriends.org/en/xampp.html) to get my environment back up
> running until i find a better solution.
>
> This problem is not Zend Framework-related.
>
> Cheers,
> Johannes
>
> 2009/11/3 Goran Juric <[hidden email]>
>
>>
>> Hi,
>>
>> I have been running phpunit tests on PHP 5.3 (on Mac OSX 10.6) and I am
>> getting an error:
>>
>> Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2000] mysqlnd cannot connect
>> to
>> MySQL 4.1+ using old authentication
>>
>> I am using the Zends PDO_MYSQL adapter and the MySQL server is running
>> version 5.0.86.
>>
>> Everything works fine on versions prior to PHP 5.3 (because there is no
>> mysqlnd :) ).
>>
>> How to fix this?
>>
>> Regards,
>>
>> Goran Juric
>> http://gogs.info/
>> --
>> View this message in context:
>> http://old.nabble.com/mysqlnd-cannot-connect-to-MySQL-4.1%2B-using-old-authentication-tp26160077p26160077.html
>> Sent from the Zend Framework mailing list archive at Nabble.com.
>>
>>
>
>