Can't connect with - MySQL

[malc]

Silly question but have you tried the Java connectors and added the class path. This caused me no end of grief. A clean install of Java and the latest connector jar file are needed.

[Agent Smith]

Silly question but have you tried the Java connectors and added the class path. This caused me no end of grief. A clean install of Java and the latest connector jar file are needed.

No, it's not silly. The solution I found also involves Java. And I will be posting it ASAP for me.

Thanks for your interest in this matter (a matter that affects a lot of us, users of PCLinuxOS)

Best regards,

[Agent Smith]

Dear Colleagues,

I have found a data modeling tool to help the work with Mysql.
It's Sql Power Architecthttp://www.sqlpower.ca/page/architect, a tool that helps the design, project and maintenance of data bases.
And, it has many nice features:
    Accesses source databases via JDBC
    Connects to multiple source databases concurrently
    Compares data models & database structures and identifies discrepancies
    Drag-and-drop source tables & columns into the playpen
    Remembers the origin of each column
    Generates source-to-target visual Mapping Reports
    Forward/reverse engineers PostgreSQL, Oracle, MS SQL Server & more
    Saves source data structure snapshots in the project, so you can work remotely
    All project data is stored in an easy-to-parse XML format
    OLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & Levels
    Free Download (Open Source, GPL v.3 licensed) (Community Edition)

Will be in testing soon, so you'll be able to test-drive it.

Regards,

[Agent Smith]

Ok, it's in the testing section: sqlpower-architect-1.0.6-1pclos2012.noarch.rpm

Take this baby for a spin and tell me what you find about it.

Sincerely,

[balduro]

Dear Colleagues,

I have found a data modeling tool to help the work with Mysql.
It's Sql Power Architecthttp://www.sqlpower.ca/page/architect, a tool that helps the design, project and maintenance of data bases.
And, it has many nice features:
    Accesses source databases via JDBC
    Connects to multiple source databases concurrently
    Compares data models & database structures and identifies discrepancies
    Drag-and-drop source tables & columns into the playpen
    Remembers the origin of each column
    Generates source-to-target visual Mapping Reports
    Forward/reverse engineers PostgreSQL, Oracle, MS SQL Server & more
    Saves source data structure snapshots in the project, so you can work remotely
    All project data is stored in an easy-to-parse XML format
    OLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & Levels
    Free Download (Open Source, GPL v.3 licensed) (Community Edition)

Will be in testing soon, so you'll be able to test-drive it.

Regards,

I'm having the same problem with workbench. It appears like a repeated problem in linux and MySQL 5.1 database version. From MySQL Workbench team says that if you downgrade the database version at 5.0 the workbechn works fine. I don't tested that because I can't downgrade. But I hope that can help.
Thanks for the sql power architect. I'll try. Other interesting stuff is navicat for MySQL.http://www.navicat.com/] [url]http://www.navicat.com/[/url]

Regards.

[Agent Smith]

Thanks for the suggestion Balduro,

Any other software you find relevant, you can ask in the package request section.

After I brought SQL Power Architect, I am going to package the 2 other programs from the same company SQL Power CA.

Since Mysql has this hiccup with Workbench and is only connecting well through Java, I would ask suggestions on more Java programs that deal with Mysql databases.

Best regards,
 

[malc]

FYI, I have just migrated my database (British Railway History......very long ongoing project!!!!) from MySQL to PostGreSQL. A bit of a pain but nothing unexpected just the usual case sensitivity, brackets, single quotes, date-times, nulls and strings....whew!  So if anyone is going through this and has any questions please feel free to email me.

Why the switch? Well in a word : Oracle (I don't trust them wrt opensource). Ironically I have 30 years Oracle flavoured SQL experience which postgres is closer to than mysql.

There is a secondary benefit in that you don't need Java to talk to postgres.

all the best,

malcolm