MySQL Bugs: #20959: Access Denied

Bug #20959	Access Denied
Submitted:	11 Jul 2006 6:13	Modified:	9 Oct 2006 13:35
Reporter:	Jonas Björklund	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.20	OS:	Windows (Windows)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any
Tags:	Generic

Description:
I get an error message when I start Query Browser:

Could not fetch Catalogs/Schema data.
The following error occured: Access denied; you need the SHOW DATABASES
priviliege for this operation.

My hosting provider has started their server with --skip-show-database.
Is it possible to get QB to list only my database?

How to repeat:
Start MySQL server with --skip-show-database.
Start Query Browser. Doesn't matter if you choose default schema or not.

Suggested fix:
Make Query Browser use "Default Schema" and not try to show any other schemas.

Thank you for the bug report. Most probably this bug is related to same
issue as bug: http://bugs.mysql.com/bug.php?id=13188

Can I do anything else? I read the other bug report and I can confirm that my bugg is on Windows.

Hi,

To fix this problem we would need to add a logic to handle this specific server mode, so basically this would be a feature request, which is not going to be satisfied this time as we are focused on making QB stable. Anyway - thanks for your report. This may be implelemented in future.