php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #28718 mysql-connect() to mysql4.1.1a-alpha-nt
Submitted: 2004-06-10 03:00 UTC Modified: 2004-06-10 09:02 UTC
From: bryantd at tpg dot com dot au Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.3.6 OS: win2000
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2004-06-10 03:00 UTC] 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'

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-06-10 09:02 UTC] derick@php.net 
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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 26 04:01:30 2024 UTC