Slashdot Mirror

← Back to Stories (view on slashdot.org)

MySQL Official GUI Interface

Posted by timothy on from the peeking-at-your-data dept.

ChopsMIDI writes "Announced today at MySQL, is the new GUI for MySQL: The MySQL Administrator. This integrates database management and maintenance into a 'seamless' GUI. 'Easily perform all the command line operations visually including configuring servers, administering users, and dynamically monitoring database health. Other common administrative tasks such as monitoring replication status, backup and restore, and viewing logs can also be performed through the MySQL Administrator graphical console.' This sounds like a pretty sweet tool, but sadly, it's not available for downlodad yet, but it does have some nice screenshots."

16 of 92 comments (clear)

  1. Similar to PgAdmin for Postgres by Anonymous Coward · · Score: 5, Informative

    Take a look

    There's also a great free front end for Oracle but its name escapes me at the moment. It's from Sweden I think.

  2. Re:Unix support? by Vaevictis666 · · Score: 4, Informative

    Says it will be initially available for Windows and Linux (Sorry Mac users, you'll need to wait).

  3. Re:Unix support? by Zathrus · · Score: 2, Informative

    They still do, but they're utter crap. No admin worth their paycheck uses them.

    Most older Oracle admins have a litany of scripts that they do their work with... usually scripts they've written over many, many years that do really nifty stuff very efficiently. Augmented by scripts from user groups, books, coworkers, and websites.

    The smart older ones and most of the younger ones also use tools like Toad or TOra (I use TOra but I am not a DBA, despite having to play one at times at work). There are some other high end tools out there for performance profiling and stuff -- they're well beyond my sphere of knowledge though.

    That said I'd be surprised if the mySQL front end didn't run under multiple OSes... certainly most of mySQLs deployment is on Linux. It'd be silly not to have the GUI tool be cross platform too.

  4. TORA - the best GPL'd GUI front end bar none by Anonymous Coward · · Score: 3, Informative

    Is here

  5. Re:Sorely needed by an_mo · · Score: 2, Informative

    if it's only to mess around with the DB, why not show the boss phpMyAdmin? I am always amazed by how good a project that is. From the screenshots I see, the GUI will have more functionality, but at least you can use phpMyAdmin from anywhere in the world with a net connection and a browser.

  6. Re:Hmm. by BrynM · · Score: 2, Informative
    Not clear from the pagewhether this is a free tool or what the licensing is -- has anybody heard?
    From the line (and link) "Sign up to be notified when MySQL Administrator is available for download!", I bet it's going to be a free tool.
    --
    US Democracy:The best person for the job (among These pre-selected choices...)
  7. At the risk of seeming stupid... by drakaan · · Score: 4, Informative
    Has everyone ignored MySQL Control Center (I've been using it for a year or so, now)?

    It looks like Administrator will be a better version (or at least more attractive), but it's not like "Oh, finally!!! a GUI interface for mySQL!!!". Granted, it's still at version 0.9.4 (*note to self: newer version than the one I'm running...have to update), but that's farther along than the currently-nonexistent Administrator.

    Well?

    --
    "Murphy was an optimist" - O'Toole's commentary on Murphy's Law
    1. Re:At the risk of seeming stupid... by OneFix+at+Work · · Score: 5, Informative

      I don't think the plan is to replace Control Center, once you look at the page and screenshots, it looks less like Control Center.

      The big giveaway for this is the fact that I don't see any way of reading table data...as a matter of fact, the more you look at it, Control Center will obvously be used more for database development and data entry, but The MySQL Administrator seems to be just that...more focused towards UNIX Administrators...

  8. Until then... MySQLFront by carrowood · · Score: 3, Informative

    Until then, I'll stick to MySQLFront (slow link). It does a pretty good job for windoze users. I do hope the new GUI is an open-source tool.

    1. Re:Until then... MySQLFront by OneFix+at+Work · · Score: 2, Informative

      From the page in the article, it seems that this is more of an Administrative tool and not a general database design tool (like MySQLFront or Control Center)...just look at the screen shots...

      User Administration
      Health Monitor
      Startup Parameters
      Backup/Restore

      These look more like an administrative command line alternative. Which would mean it's providing a tool that has not been offered in another MySQL compatible app...

      This is actually a feature offered by some advanced commercial databases...it's obviously just a sign that MySQL is coming into its own...

  9. Re:If only PostgreSQL had one... by questionlp · · Score: 3, Informative

    Per a previous post, there is and has been one called pgAdmin. It may not be as pretty as the one just announced, but it's cross-platform and does a fairly good job IMNSHO.

  10. Re:Sorely needed by Anonymous Coward · · Score: 1, Informative
    i've used various web-based php admin tools and I think they suck for doing anything serious. Not their fault, it's the nature of http/html.

    A real application would be so much nicer.

  11. Mascon?? by ajayrockrock · · Score: 3, Informative

    The Windows users here at my work swear by Mascon. It's 50 bucks and really cool. Makes my installation of phpMyAdmin pale in comparison. They do make a linux version but it's nowhere near as good as the Win32 version (at least it wasn't last time I looked at it six months ago)

    later,
    ajay

  12. While your waiting... by agwis · · Score: 3, Informative

    I look forward to this being released. I've tried several different gui's for working with MySQL but have not found one that does everything I hoped for. Until it's released, I've found combining Dbvisualizer and phpMyAdmin works.

    It would be really nice to have the features of both all combined in one nice gui...which is what I hope this will be.

    -Pat

  13. Re:Sorely needed by beowulfcluster · · Score: 2, Informative

    You could show the boss MySQLFront also.

    http://www.mysqlfront.de/

    Windows only, free as in beer, but pretty nice for what it is. It seemed to have gone away for a while but now they're back. Anyone know what happened there?

  14. Other very useful software by StephanTual · · Score: 2, Informative

    DB Designer by FabForce.net is also an invaluable addition to any MySQL toolkit.