1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Any software to manage SQL database?

Discussion in 'MySQL' started by stinker, Apr 23, 2010.

  1. #1
    Hello, Im sotty if this is silly question, im new to this and im wondering is there any software to manage databases instead browser based managing?

    Thanks you! :)
     
    stinker, Apr 23, 2010 IP
  2. cDc

    cDc Peon

    Messages:
    127
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Try downloading the MySql workbench - its free to download from the mysql site.

    Make sure you download the 5.2 beta version as it is this one that enables server administrations and sql queries.
     
    cDc, Apr 23, 2010 IP
    stinker likes this.
  3. stinker

    stinker Well-Known Member

    Messages:
    628
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #3
    Thanks mate, just started to download it! :D
     
    stinker, Apr 23, 2010 IP
  4. peoplesmind

    peoplesmind Active Member

    Messages:
    107
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #4
    via the browser you can look into phpMyAdmin, which is free software. If you prefer connecting via a Windows GUI interface, mysql does have several tools to connect to a database. The advantage of browser-based sessions, is you can restrict queries locally, and never have to open the mySQL port up to any outside traffic.
     
    peoplesmind, May 2, 2010 IP
  5. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #5
    Navicat is the best I've ever used. Workbench is great for visual design but Navicat is much better for creating, editing, and general day-to-day management.
     
    jestep, May 3, 2010 IP
  6. crashus

    crashus Active Member

    Messages:
    90
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #6
    Phpmyadmin is really the best, SQL Yog is cool also
     
    crashus, May 6, 2010 IP
  7. CLDPFY

    CLDPFY Peon

    Messages:
    76
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Along with Workbench, MySQL also has a graphic query browser and an administrator gui tools. I use both of them and they work quite well.
     
    CLDPFY, May 20, 2010 IP
  8. graspit

    graspit Peon

    Messages:
    87
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    There are software that are not secure, so be careful!
     
    graspit, May 23, 2010 IP
  9. windy

    windy Active Member

    Messages:
    1,093
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    78
    #9
    phpMyAdmin in cpanel
     
    windy, May 26, 2010 IP
  10. jaikanth12

    jaikanth12 Guest

    Messages:
    119
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Pretty much everything you can do with serverside SQL managers like phpMyAdmin and it, can be done remotely and portably with any SQL data base
     
    jaikanth12, Jun 1, 2010 IP
  11. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #11
    There are many options as mentioned earlier. I have recently seen another good tool MyWebSql. Here is a list of MySQL GUIs you can choose from.
     
    mwasif, Jun 6, 2010 IP
  12. segzeey

    segzeey Active Member

    Messages:
    350
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    78
    #12
    The best is phpmyadmin its easy to use and common. You can even get it in your site admin panel.
     
    segzeey, Jun 6, 2010 IP
  13. sketchx

    sketchx Member

    Messages:
    97
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #13
    MySQL Workbench is quite nice, and its free. It might be a bit overwhelming for someone who is not familiar with those kind of tools. You have to go a step at the time. :)

    phpmyadmin is nice also but a bit old.
    But hey, they are free, so cant really complain, i personally prefer the MySQL Workbench.

    Cheerio
     
    sketchx, Jun 10, 2010 IP
  14. milan202

    milan202 Peon

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #14
    I have down loaded My sql yog but not knowing how to deal with it..if any one know then please share here...

    thanks in advance....
     
    Last edited: Jun 21, 2010
    milan202, Jun 21, 2010 IP
  15. phpmatt

    phpmatt Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #15
    What is the problem with browser based, I agree with others phpMyAdmin is all you need
     
    phpmatt, Jun 22, 2010 IP
  16. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #16
    Try using one of the desktop ones like Navicat. They're so much better and more efficient that there's no comparison. For any designer that needs to do anything but the most basic database usage on a single server, Navicat is an investment that will easily pay for itself in productivity. I can manage databases on 50 different servers at a time, and manage remote backups, scripting, reports, and anything else on every database.
     
    jestep, Jun 22, 2010 IP
  17. milan202

    milan202 Peon

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #17
    I have already used Navicat software, but not satisfied yed. how is mysql yog ? ...one of my friend, recently pass his computer engineering, suggest me that software........
     
    milan202, Jun 27, 2010 IP
  18. Chuckun

    Chuckun Well-Known Member

    Messages:
    1,161
    Likes Received:
    60
    Best Answers:
    2
    Trophy Points:
    150
    #18
    I swear by phpMyAdmin! It's genius!
     
    Chuckun, Jun 28, 2010 IP
  19. milan202

    milan202 Peon

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #19
    I think that software already build in hosting control panel, right ?
     
    milan202, Jun 28, 2010 IP
  20. Rev Jain

    Rev Jain Active Member

    Messages:
    202
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    80
    #20
    i think SQL server is a one type of database software.
     
    Rev Jain, Jul 19, 2010 IP