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

go to bug id or search bugs for

Bug #55558 MySQL returns incorrect error message for test
Submitted: 2011-08-31 22:06 UTC Modified: 2011-09-02 11:13 UTC
Votes:1
Avg. Score:3.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: simon at welsh dot co dot nz Assigned:
Status: Wont fix Package: MySQL related
PHP Version: 5.4SVN-2011-08-31 (SVN) OS: Mac OS 10.7
Private report: No CVE-ID: None
View Developer Edit
 [2011-08-31 22:06 UTC] simon at welsh dot co dot nz 
Description:
------------
With MySQL 5.5.10-log (64 bit package, downloaded from mysql.com), if the user 
does not exist when connecting to the database, the error message returned is:
Access denied for user 'rootunknown_real'@'localhost' (using password: NO)
even when a password is supplied. This breaks both mysql_connect.phpt and 
mysql_pconnect.phpt in 5.4, as they are expecting the result to be (using 
password: YES).

This also happens when running mysql from the command line, so the test should 
work around it.

If the two test cases my patch changes should be testing for YES, instead of just 
an error, then change the connect/pconnect call to use $user rather than $user . 
'unkown_real'

Patches

mysql_connects_error (last revision 2011-08-31 22:07 UTC by simon at welsh dot co dot nz)

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2011-09-02 11:13 UTC] uw@php.net
-Status: Open +Status: Wont fix
 [2011-09-02 11:13 UTC] uw@php.net 
This is a MySQL server bug. Update to MySQL 5.5.15 and it's gone. If the test was not that strict, this MySQL server bug had never been found.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Tue Oct 15 22:01:26 2024 UTC