• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

newbie to MySql how to visualize?

 
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 1071
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 755
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thanks

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

what do you recommend?
 
Ranch Hand
Posts: 405
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 1071
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 755
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thanks I'm using eclipse as my IDE so i guess I'll try Quantum DB for that.
 
reply
    Bookmark Topic Watch Topic
  • New Topic