#23252 [Com]: Incorrect MySQL client version compiled in PHP

ID: 23252 Comment by: arjen at mysql dot com Reported By: j dot katarski at ecu dot edu dot au Status: Bogus Bug Type: MySQL related Operating System: Windows XP SP1 PHP Version: 4.3.2RC1 Assigned To: georg New Comment: Simple solution: you can use the --old-passwords option in the MySQL 4.1 (or higher) server, to be able to connect from the PHP 4 mysql extension. See here for more info: http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html The mysqli extension in PHP 5 speaks the new protocol. Previous Comments: ------------------------------------------------------------------------ [2003-04-24 04:08:01] georg@php.net In MySQL 4.1 they changed the authentication protocol and password() function. To use 3.23 client library you must copy the mysql-tables from an older version into your datadirectory. As long 4.1 is still alpha we cannot provide a bundled library. ------------------------------------------------------------------------ [2003-04-23 03:12:52] sniper@php.net That's what you get when using beta/alpha software. Use a stable mysql release and it will all be fine. ------------------------------------------------------------------------ [2003-04-23 00:44:05] j dot katarski at ecu dot edu dot au <? echo mysql_get_client_info(); $conn = mysql_connect("server.with.mysql4.1", "username", "password"); ?> Returns the following information: 3.23.49<br /> <b>Warning</b>: mysql_connect() [<a href='http://www.php.net/function.mysql-con nect'>function.mysql-connect</a>]: Client does not support authentication protoc ol requested by server. Consider upgrading MySQL client in <b>my php filename</b> on line <b>3</b><br /> It was outlined earlier that PHP4 will *NOT* support MySQL 4.1. ------------------------------------------------------------------------ [2003-04-23 00:15:05] sniper@php.net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2003-04-18 12:48:58] georg@php.net changed status to feedback ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/23252 -- Edit this bug report at http://bugs.php.net/?id=23252&edit=1