Bug #32997 Failed to load schemata - reverse engineer database
Submitted: 5 Dec 2007 12:21 Modified: 11 Dec 2007 15:08
Reporter: Graham Shipman Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.10 SE Beta OS:Windows (XP & Vista)
Assigned to: CPU Architecture:Any

[5 Dec 2007 12:21] Graham Shipman
Description:
When trying to reverse engineer the database, Workbench connects to the database but then fails to retrieve description from DBMS. Advanced error message:

SELECT command denied to user 'workbench'@'217.23.228.162' for table 'schemata'

On both machines (XP & Vista) I am able to connect using Workbench 1.1 alpha, with the same settings I am using for this version.  There is no table called 'schemata' on my database.

How to repeat:
Happens every time.
[5 Dec 2007 17:50] Valeriy Kravchuk
Thank you for a problem report. Please, send dump of problematic database.
[10 Dec 2007 17:09] Sergei Tkachenko
Could you also specify your MySQL DBMS version?
[10 Dec 2007 17:47] Graham Shipman
Can't send dump of problematic database as the zipped dump file is 19Mb.

Database version is MySQL 4.1.12

Thanks

Graham
[11 Dec 2007 15:08] Sergei Tkachenko
Operations like forward/reverse engineering now rely on presence of information_schema (as opposed to those in Workbench v1.x), thus min supported DBMS version for these operations is 5.0.2. We advice to use latest releases of 5.0/5.1 brunches. Related note was added to FAQ - Technical Questions.