MySQL Bugs: #13151: Reverse Engineering shows schemata not on server

Bug #13151	Reverse Engineering shows schemata not on server
Submitted:	13 Sep 2005 19:27	Modified:	17 Mar 2006 9:16
Reporter:	Greg Howard	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S3 (Non-critical)
Version:	1.0.1a	OS:	Windows (Win2k SP4)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
When choosing to reverse engineer an existing schemata, after entering the connection information a list of schemata to choose from includes names that do not exist on the MySQL 5.0.11-beta-nt-max test server.  These names are BOOKKEEPING, SCOTT, SYS.  If one of these schema is selected, the Reverse Engineering Wizard fails to connect.

Once the connection has failed, clicking the Advanced button displays the following text:

The schema(ta) could not be reverse engineered (error: 0).
ReverseEngineeringMysql.reverseEngineer :Could not change to given schema.
Details: 
BOOKKEEPING

MySQL Error 1049: Unknown database 'bookkeeping'

How to repeat:
- Open app
- Press Ctrl+R or click the Database Menu and choose Reverse Engineering
- Fill in the hostname with localhost
- Leave the port set to 3306
- Fill in the user name with root
- Fill in the password with the root user password
- Click next
- Verify that Retrieve schema information from source database system was successful
- Click next
- See BOOKKEEPING, SCOTT, and SYS are there
- Highlight BOOKKEEPING and click next
- Red X's appear in execution tasks
- Click on Advanced button to view error message

To have the extra schema disapear, when you see the list of extra schema:
- Click back
- Click next
- See BOOKKEEPING, SCOTT, and SYS are not there anymore

Thanks for your bug report.  I was able to reproduce this under XP/SP2

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