Bug #13186 Crashes on Backup screen with Access denied for user
Submitted: 14 Sep 2005 15:55 Modified: 14 Sep 2005 20:10
Reporter: Keith Byrne Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.0.20 OS:Windows (Windows XP SP2)
Assigned to: Bugs System CPU Architecture:Any

[14 Sep 2005 15:55] Keith Byrne
Description:
I have a hosting package with Network Solutions and on their mySQL server where they have over 3,300 dbs for all their users.

My problem arises when I user MySQL Administrator to try and make a backup. When you create a new project, you must wait a while for the schema list to populate. When it does, you then type in the database name, but as you do, the app fails with;

  A MySQL error was encountered. The message is:
  
  Could not fetch schema tables.
  The following error occurred: Access denied for user:
  'xxx' to database 'a' (1044)

This will appear a few times then, the next error appears,

  Access violation at address 003455E6 in module 'libmysqlx.dll'. Read of address 0000028C

No matter how many times you click OK, the app is dead and must be end tasked.

Now, this is obviously because I don't have the privs to view most of the 3,300 dbs that are on the server, but it seems MySQL Admin is trying to read the info with each schema, or at least the first one or two.

How to repeat:
Connect to a MySQL server with lots of schemas and where you are a user that has only full privs on 1 schema. Where the name of that 1 schema is not within the first few schema names.
[14 Sep 2005 20:10] Jorge del Conde
Hi!

I was unable to reproduce this bug
[14 Sep 2005 22:18] Keith Byrne
I forgot to mention that you have only privs on 1 schema and no privs whatsoever on the other schemas.
[14 Sep 2005 22:30] Keith Byrne
You can log onto this blank database
Username: mysqlbug
Password: mysqlbug
Database: schemabug
Host: 205.178.146.15