MySQL Bugs: #13063: Use of SHOW DATABASE command should not be forced.

Bug #13063	Use of SHOW DATABASE command should not be forced.
Submitted:	8 Sep 2005 12:38	Modified:	3 Oct 2005 9:43
Reporter:	Michael Kaandorp	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.2	OS:	Windows (XP SP1a)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
When I login to a server where I don't have root privileges I get the error:
"Access denied. You need the SHOW DATABASES privilege for this operation (1227)"

I don't have this privilege on the server, but I do have an account on the server. It looks like the server is doing "SHOW DATABASES;: no matter what you do.

How to repeat:
Just login with a useraccount that doesn't have the SHOW DATABASE privilege. It would then be impossible to work with your database.

Suggested fix:
It might be better to only send the "SHOW DATABASES" command if there is no default database filled in into the Instance Administration dialog box.
When you do fill in a database name the "SHOW DATABASES" command should be omitted. At the moment I think that this is not the case.

Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Problem still excists in version 1.1.3. Please change status to open.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html