File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes newbie to MySql  how to visualize? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "newbie to MySql  how to visualize?" Watch "newbie to MySql  how to visualize?" New topic
Author

newbie to MySql how to visualize?

Peter Primrose
Ranch Hand

Joined: Sep 10, 2004
Posts: 755
All,

Well, I've been using MS access as my db and had great experience with it. It�s very straight fw and easy to use (constructing tables changing attributes�).

Now, I have to use MySql (I understood it�s more robust). I downloaded MySql and realized that most of the constructions (building a table eg) are done with a DOS window. I wonder if there�s a program that make life easier by visualizing the db; I mean show the tables, the attributes and able to query it.

Any idea?

Ppr
Steven Bell
Ranch Hand

Joined: Dec 29, 2004
Posts: 1071
There are two you will want to get. They each have their uses. The first is MySQL Administrator, and the next is MySQL Control Center.

For some reason I couldn't find a direct link to the MySQL Control Center from MySQL's products page(had to search goole for the link). Although it is still on their site I wonder if they have plans to get rid of it. I hope not as the admin tool can't do half the stuff the control center does. Does anybody have any idea if there is a push to get rid of the control center?
Peter Primrose
Ranch Hand

Joined: Sep 10, 2004
Posts: 755
thanks

I have just received an email from a friend suggesting me to use: DbVisualizer .

what do you recommend?
Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
I also would like to recommend the :
]MySQL Control Center.

But, MySQL Client is no longer under development. You can still download it for use. I am able to do a little bit of both the Administration and Query creation from one GUI.


Development of MySQLGUI has been suspended. Our current development efforts are directed towards the development of MySQL Administrator and MySQL Query Browser. [/QUOTE
Steven Bell
Ranch Hand

Joined: Dec 29, 2004
Posts: 1071
DBVisualizer is a good tool. It is not DB specific, we use it at my work to look at DB2 databases. I don't really use it much though, I use an eclipse plugin called Quantum DB. I'm not sure if DB Visualizer will give you all the abilites to manage users, accounts, outside access, ect, that the MySQL tools (mainly the admin tool) will. DB Visualizer might be able to replace the MySQL Control Center. I would probably just play with them all and see what you like.
Peter Primrose
Ranch Hand

Joined: Sep 10, 2004
Posts: 755
thanks I'm using eclipse as my IDE so i guess I'll try Quantum DB for that.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: newbie to MySql how to visualize?
 
Similar Threads
WebSphere 5.0 and mySql
Help
populate all data from old database to a new one.
Let Hibernate generate tables ?
Migrating from mysql to mssql