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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: bryantd at tpg dot com dot au
New email:
PHP Version: OS:

 

 [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

Pull Requests

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 Dec 27 01:01:28 2024 UTC