From: bryantd at tpg dot com dot au
Operating system: win2000
PHP version: 4.3.6
PHP Bug Type: MySQL related
Bug description: mysql-connect() to mysql4.1.1a-alpha-nt
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 [EMAIL PROTECTED] 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 bug report at http://bugs.php.net/?id=28718&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28718&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28718&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=28718&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=28718&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=28718&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=28718&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=28718&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=28718&r=support
Expected behavior: http://bugs.php.net/fix.php?id=28718&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=28718&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=28718&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=28718&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28718&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=28718&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=28718&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=28718&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=28718&r=float
