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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.