How do I edit MySQL databases directly?

Discussion in 'Web Design and Development' started by ravenvii, Sep 17, 2007.

  1. ravenvii macrumors 604

    ravenvii

    Joined:
    Mar 17, 2004
    Location:
    Melenkurion Skyweir
    #1
    ^^^

    I want to edit something in my database, but I don't know how to access it.

    (I'm new to all this MySQL stuff, so be gentle :) )
     
  2. ChicoWeb macrumors 65816

    ChicoWeb

    Joined:
    Aug 16, 2004
    Location:
    California
    #2
    Do you have PHPAdmin installed on your server? It's relatively easy to navigate through based on the level of your understanding.

    I use Navicat, which is a really nice GUI for MySQL.
     
  3. bld44 macrumors 6502

    Joined:
    Apr 21, 2007
  4. ChicoWeb macrumors 65816

    ChicoWeb

    Joined:
    Aug 16, 2004
    Location:
    California
    #4
    Sure:rolleyes:
     
  5. ravenvii thread starter macrumors 604

    ravenvii

    Joined:
    Mar 17, 2004
    Location:
    Melenkurion Skyweir
    #5
    Yup, that worked like a charm!

    Thanks guys!

    Now that I know the site is reading the database fine, now I gotta find out why it wouldn't WRITE to the database.

    Will probably post a thread about that :rolleyes: @ self

    Thanks! :)
     
  6. CANEHDN macrumors 6502a

    CANEHDN

    Joined:
    Dec 12, 2005
    Location:
    Eagle Mountain, UT
    #6
    PHPmyAdmin? Why not just use the mySQL GUI tools?
     
  7. ChicoWeb macrumors 65816

    ChicoWeb

    Joined:
    Aug 16, 2004
    Location:
    California
    #7
    What are those?
     
  8. Sherb macrumors member

    Joined:
    Jun 6, 2007
    Location:
    Colorado
    #8
    Instead of PHPmyAdmin there is a great alternative called MySQL Quick Admin. Might want to check it out :) I prefer it much more.
     
  9. Mac In School macrumors 65816

    Joined:
    Jun 21, 2007
    #9
    I like Navicat. Just keep in mind, that some hosting companies don't allow remote access through GUI interfaces. 1and1 does not.
     

Share This Page