Bug #6003 PHP mysql library doesn't connect for non-admin
Submitted: 10 Oct 2004 7:06 Modified: 7 Feb 2005 11:21
Reporter: Vasily Perepizdenko Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.1 OS:Windows (WinXP)
Assigned to: CPU Architecture:Any

[10 Oct 2004 7:06] Vasily Perepizdenko 
Description:
PHP mysql client (PHP ver. 5.0.2) doesn't connect with the following message: Table 'ÔG' from one of the SELECTs cannot be used in in ...
Connection failed . 

How to repeat:
mysql_connect("localhost", "username", "password") throws the error above if "username" is not a MySQL admin in 5.0.1. Looks like mysqli_connect() works fine; and mysql() works fine for admin user (that is, the user with "ALL PRIVILEGES" on the database. It may be PHP problem; however, PHP connects fine to MySQL ver. 4.1.4
[7 Feb 2005 11:21] Hartmut Holzgraefe 
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.