#28718 [Opn->Bgs]: mysql-connect() to mysql4.1.1a-alpha-nt

ID: 28718 Updated by: derick@php.net Reported By: bryantd at tpg dot com dot au -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: win2000 PHP Version: 4.3.6 New Comment: Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php You need to use an external libmysql library that matches MySQL 4.1.1. Previous Comments: ------------------------------------------------------------------------ [2004-06-10 03:00:37] bryantd at tpg dot com dot au Description: ------------ hope this is correct way I beleive mysql has a new authentication protocol in mysql4.1.1 which is not supported by PHP causing the following error Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\www\testDatabaseConnect.php on line 8 Database connection failed apache 2.0.49 php 3.3.6 mysql 4.1.1a-alpha-nt win2000 when using following <!doctype html public "-//W3C//DTD HTML 4.0 //EN"> <html> <head> <title>Title here!</title> </head> <body> <?php $connect = mysql_connect('localhost','jsmith','Secret15'); if ($connect==FALSE) { print "Database connection failed"; exit; } //mysql_select_db('accounts',$connect); ?> </body> </html> when I use the it works fine c:\mySQL\bin>mysql -ujsmith -pSecret15 mysql> show databases ; +----------+ | Database | +----------+ | accounts | | test | +----------+ Used folloing to create user account grant all on accounts.* to jsmith@localhost identified by 'Secret15'; MySQLcc shows mysql\user localhost, jsmith, *b648etc, next 21 fields show 'N' mysql\db localhost, accounts, jsmith, 6 by 'Y',grant-priv 'N', 5 by 'Y' ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28718&edit=1