1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mySQL - recommend a program for relational database design

Discussion in 'BlackHat Lounge' started by tony-raymondo, Sep 11, 2011.

  1. tony-raymondo

    tony-raymondo Junior Member

    Joined:
    Jun 19, 2009
    Messages:
    181
    Likes Received:
    459
    Hi

    I'm used to the old days of making relational databases in MS Access.

    e.g. i'm used to working with layouts like this:

    [​IMG]

    in the past, i've never worked with anything other than the ms access MDB file.

    But i'm finally getting into sql and phpmyadmin, and I don't know where to start????

    What is the MS Access equivalent here? Do i want to use MySQL Workbench?

    e.g. how do i work on relational databases for export to phpMyAdmin.

    forgive my ignorance :eek: Thanks!
     
  2. wizzardz01

    wizzardz01 Power Member

    Joined:
    Jan 7, 2010
    Messages:
    572
    Likes Received:
    337
    Occupation:
    Digital Marketing Director
    Location:
    Bosnia and Herzegovina
    If you using windows try putty and MySQL Query Browser. Google about it ;)
     
    • Thanks Thanks x 1
  3. olimix

    olimix Regular Member

    Joined:
    Jul 21, 2010
    Messages:
    232
    Likes Received:
    71
    Location:
    11h11 brothers
    online sql editor :
    Code:
    http://ondras.zarovi.cz/sql/demo/?keyword=default
    you can download it too

    it's working perfectly with phpmyadmin , generated code is ready to be import
     
    • Thanks Thanks x 1
  4. trophaeum

    trophaeum Senior Member

    Joined:
    Dec 21, 2007
    Messages:
    1,189
    Likes Received:
    706
    use visio
     
    • Thanks Thanks x 1
  5. tony-raymondo

    tony-raymondo Junior Member

    Joined:
    Jun 19, 2009
    Messages:
    181
    Likes Received:
    459
    1. putty
    2. MySQL Query Browser
    3. visio
    4. http://code.google.com/p/wwwsqldesigner/

    hmm...

    i use windows XP - i forgot to mention that.

    i'm kinda looking for a program that I can download and model a database on -- offline if possible.
     
  6. judson

    judson Power Member

    Joined:
    Nov 29, 2009
    Messages:
    530
    Likes Received:
    319
    Occupation:
    Fulltime Newbie IM
    Location:
    Sub Ubi
    There are a few.

    The problem though, is security. By default, mySQL is set up to not allow any connections from anything other than localhost. Check that your host has not set yours up differently. If you can't connect remotely, your question is moot.

    If you can, you can even use Access to connect to your mysql DB.
     
  7. KeyzDT

    KeyzDT Power Member

    Joined:
    Aug 9, 2010
    Messages:
    756
    Likes Received:
    365
    putty....*shiver*
     
  8. thinkdevoid

    thinkdevoid Regular Member

    Joined:
    Aug 30, 2011
    Messages:
    446
    Likes Received:
    131
    Location:
    192.168.1.1
    mysql workbench
     
  9. darkmonk

    darkmonk Regular Member

    Joined:
    Nov 21, 2007
    Messages:
    226
    Likes Received:
    52
    MySQL workbench has an ER modeling tool built in. To be honest, I didn't really like it, but it is free and workable. Download and install the full MySQL pack locally, do your ER model, then script it and run the script on your server to deploy. Better to do it this way then open up external access to your server db. If you want to spend $$$ there's always ERWin or Embarcadero's stuff.
     
  10. trophaeum

    trophaeum Senior Member

    Joined:
    Dec 21, 2007
    Messages:
    1,189
    Likes Received:
    706
    visio comes with office, you just need an odbc driver to talk to the db to send the create table queries, hate to say it but i still use visio myself, i cant find something decent to replace it
     
  11. Florist88

    Florist88 Newbie

    Joined:
    Jul 24, 2009
    Messages:
    43
    Likes Received:
    7
    try Toad for mysql (freeware)