Follow Slashdot stories on Twitter

 


Forgot your password?
Close
typodupeerror
×
Announcements Data Storage Software

MySQL Official GUI Interface 92

Posted by timothy 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."
This discussion has been archived. No new comments can be posted.

MySQL Official GUI Interface More

MySQL Official GUI Interface

Comments Filter:
  • It's about bloody time. Shame it's only screencaps in the meantime. Oh, hey, FP! =^_^=

  • Unix support? (Score:3, Interesting)

    by acomj ( 20611 ) on Wednesday January 21, 2004 @03:32PM (#8047328) Homepage
    Oracle used to (maybe they still do) all there front ends and installers in java so they were cross platform. They show an XP screen shot, but don't seemed to detail what platforms this will run under.

    • Re:Unix support? (Score:5, Informative)

      by Vaevictis666 ( 680137 ) on Wednesday January 21, 2004 @03:39PM (#8047425)
      Says it will be initially available for Windows and Linux (Sorry Mac users, you'll need to wait).

    • Re:Unix support? (Score:3, Informative)

      by Zathrus ( 232140 )
      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 othe
      • I don't really understand why anyone really needs a GUI to admin a MySQL server-- I suppose it is nice, though. What I'd like to know is: are there any good front-ends to ANY databases that run on Linux. Requirements: free software license, table linker (preferably capable of linking any ODBC-available table), data editor (sheet or form, I don't care, just something to make data entry/editing easier), drag-and-drop query editor (maybe a tree of all linked tables to the right where you can drag fields into a
    • Well, I think the screenshot was from XP because the thing is based on the Database Manager of former SAPDB (now MaxDB from MySQL).

      This tool (SQPDB Database manager) was never ported to anything elese but windows. Now, it seems like the guys form SAPDB camp who where allocated to MySQL MaxDB camp are porting it to *X (GTK?) and adding the MySQL features (MYISAM, InnoDB ...).

      Just my 2c.

      bb4now,
      PMC

  • Hmm. (Score:2)

    by daeley ( 126313 ) *
    Not clear from the pagewhether this is a free tool or what the licensing is -- has anybody heard?

    (Also not available for OS X initially, but whatever.)

    • Re:Hmm. (Score:3, Informative)

      by BrynM ( 217883 ) *
      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! [mysql.com]", I bet it's going to be a free tool.
      • From the same link [mysql.com] (look at "platforms"), it looks like Mac OS X has been lumped under the general term "Linux", so don't count it out yet... :)
      • Not necessarily...you may still need to pay for it to be fully functional or to be used for more than a certain period of time.
    • The licensing [mysql.com] link takes you to the standard MySQL dual licensing page--commercial ($) license for use in commercial products and MySQL Open Source License. Although the licensing page doesn't mention the administrator explicitly, the licensing faq [mysql.com] says

      What is MySQL's software licensing model?

      MySQL uses a "dual licensing" business model. Under this model, users may choose to use MySQL products under the free software/open source GNU General Public License (commonly known as the "GPL") or under a commer

  • As a diehard mysql user/developer, I'm very excited for this tool to be released! It looks like it will compliment Mysql's CLI interface nicely.
  • This sounds like a pretty sweet tool

    mmmmm... sweet, GUI tool.

    -----
    P. Hilton

  • Sorely needed (Score:5, Interesting)

    by Spudley ( 171066 ) on Wednesday January 21, 2004 @03:37PM (#8047394) Homepage Journal
    This is a very welcome addition to the package. I know we've had tools like MySQL Navigator for a while, but they are fairly limited.

    At the end of the day, MySQL is competing directly with MS SQL Server, which comes with Enterprise Manager. And no matter how easy it is to crash EM, it's what the boss sees when he makes his purchasing descision.

    I personally know of at least one commercial web site that is using MS SQL and ASP, which won over MySQL and PHP purely on the fact that the buyer liked the being able to mess around with the DB with a GUI. The fact that he hasn't touched it since, and the developer hardly uses it either are beside the point.

    But I do hope that the MySQL GUI doesn't have the same propensity to crash in the middle of a multi-table DB update like EM does. :(

    All that said though, EM is a very capable tool, and has made plenty of DB administrators out of people who really aren't very adept with the SQL langauge itself (...kinda like the rest of Microsoft's products, if you think about it). When MySQL can do the same thing, it will go a long way toward helping itself and Linux on the road to general acceptance.

    • Re:Sorely needed (Score:3, Informative)

      by an_mo ( 175299 )
      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.

      • Re:Sorely needed (Score:1, Informative)

        by Anonymous Coward
        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.

        • True, especially for row editing or large amounts of data entry and updates. I'll take a console over phpmyadmin any day of the week. It's just faster not to muck around with a clunky web interface.
    • 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?

      • Re:Sorely needed (Score:2, Funny)

        by pmsr ( 560617 )
        Yes, back indeed, this is good news. And with yummy features like multi skin support, no one should miss it. Now, let me look at my desktop, is there something left that is not skinnable? Notepad maybe. Bubble gum skin for Notepad, any takers? ;-)

        /Pedro

    • Re:Sorely needed (Score:3, Interesting)

      by trix_e ( 202696 )
      this is seriously not a troll...

      I'm as happy as anyone to see this tool for MySQL, I've often wished for something as robust (or nearly so) as Enterprise Manager for MySQL, but I've not had the same experiences with EM crashing that you have.

      I've used EM extensively (almost daily) since SQLServer 2K came out, and can't recall the last time it crashed... Sure, there are a few bugs that are annoying, but it's a pretty damn nice piece of software (along with SQL Server itself) for the price.

      Sure there are

    • Re:Sorely needed (Score:2, Interesting)

      by rainman_bc ( 735332 )
      Uh, multi-table update in EM? Uh, not only is that a difficult task to accomplish, it's unnecessary. DBA's use Query Analyzer for that sorta stuff. Use EM for schema changes, not ad-hoc queries. EM's good for building tables, mediocre for stored procs, fantastic for building views, constraints, triggers, indexes, etc. The right tool for the right job. If you use EM to run ad-hoc queries, you're using the wrong tool buddy. The MySQL tool looks pretty darn swanky though.
    • EM is a very capable tool, and has made plenty of DB administrators out of people who really aren't very adept with the SQL langauge itself

      There's no such thing as a DBA that isn't very adept with the SQL language. If you don't know SQL then you're just tinkering around and calling a consultant when something real needs to get done.

  • Similar to PgAdmin for Postgres (Score:5, Informative)

    by Anonymous Coward on Wednesday January 21, 2004 @03:38PM (#8047418)
    Take a look [pgadmin.org]

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

  • cannot WAIT for this (Score:5, Funny)

    by gbd ( 242931 ) on Wednesday January 21, 2004 @03:51PM (#8047581)
    hi (george here)

    i think this is a GREAT idea!! i set up my sql a long time ago, my damn WIFE used to keep all of her recipes on these god damn INDEX CARDS in the kitchen and they kept cluttering the place up!! so then she entered ALL of her recipies into my sql and then THREW all her cards away!! so then one morning i wake up and i say make me some FRENCH TOAST!! and then she goes to the computer and brings up my sql and can't figure out how to FIND the damn recipe!!

    so i say just run a select statement and she is like george i cannot run a select statement i do not know how!! so i sit down and DAMN IT i forgot how to do it too!! so now ALL her recipes are stuck in my sql!! no more pork chops or ham cutlets!! we've been eating fucking beanie weenie for FIVE GOD DAMN YEARS!! select this from that, now WHAT in the HELL!! all i want is some effing french toast!! god!! now that there is a gui available she should be able to find the recipe and cook breakfast for REAL again i simply cannot wait!!

    your buddy
  • I was skeptical at first, but I looked at the screenshots. That is really freakin' slick. Should make managing a database much easier. I think I just might try it out when it hits the portage tree, if it hasn't already.
  • ...is still vaporware. Why all this noise over a tool that doesn't even have a release date?

    The usually reason for making an announcement like this is to make people focus on your hypothetical feature instead of the real features of competing product. Which is not very honest. Which is why we dump on companies like Microsoft and Oracle when they do it. So why is MySQL any different?

    • A product that's just been announced is not vaporware. The term implies deception and without knowing the real status of the project, there needs to be an announced release date or some sort of an obvious show stopper (company goes under, loss of major developer, similar tool released by same group, etc).

      And with all of the screenshots, I am pretty sure they actually have a product in development...no use in doing so many mock ups of a product for a simple "coming soon" page...

      • A product that's just been announced is not vaporware. The term implies deception and without knowing the real status of the project....

        Yep, that's my understanding of the word too.

        ...there needs to be an announced release date or some sort of an obvious show stopper...

        Well, I admit that "we'll have this done someday" isn't quite as blatant as "coming (insert mythical date here)!" But neither strikes me as particularly honest.

        And with all of the screenshots, I am pretty sure they actually have a pro

        • ok but this is an open source product that is freely downloadable. They don't stand to make money with this, there is no reason to generate false buzz.
        • "No use"? The purpose of a vaporware announcement is to generate buzz. You sound pretty buzzful to me.

          You sound like developers set out to create vaporware. Vaporware generally happens when a management group mis-represents the product as being ready or feasable when it is neither. This is less likely in OSS...

          Why else no Linux screenshots? If they had them, they'd certainly show them, given the Linux bias of the typical MySQL user.

          Gee, I don't know...maybe because that's their primary audience for

          • Vaporware generally happens when a management group mis-represents the product as being ready or feasable when it is neither.

            In my experience, management more often sets unrealistic goals out of sheer ineptitude. But people general assume malice where stupidity is a sufficient explanation.

            This is less likely in OSS...

            Lots of OSS project promote themselves to death. Look at all the blurbs the KDE people are always putting out. And KDE's at least a non-profit. MySQL AB is a for-profit business. Just be

        • No Linux screenshots.

          Apart of course from the GTK based frontend.

  • At the risk of seeming stupid... (Score:5, Informative)

    by drakaan ( 688386 ) on Wednesday January 21, 2004 @04:10PM (#8047815) Homepage Journal
    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?

    • I have to agree. I have beening using MySQL CC for quite some time now. I've never had a problem with it and it works very well for me. If MySQL does charges for this I won't be buying it.
    • I was just thinking this same thing after flicking through the comments. MySQL Control Center is a rather nifty program that does pretty much everything I could think of with a MySQL server. Much like the Enterprise Manager for MS SQL Server
    • Has everyone ignored MySQL Control Center (I've been using it for a year or so, now)?

      My thoughts exactly. At work, we've just started getting into MySQL more seriously, and MySQLCC has been quite useful.

    • Re:At the risk of seeming stupid... (Score:5, Informative)

      by OneFix at Work ( 684397 ) on Wednesday January 21, 2004 @05:53PM (#8049231)
      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...
  • I am a big fan of PostgreSQL, but we still lack a great GUI interface to it. phpPgAdmin is wonderful, but not quite as good as phpMySql. I'm a Mac fellow, and love CocoaMySQL. I wish there were one for PostgreSQL. Certainly, admin of PostgreSQL is more complex and we need such a tool desperately.

  • Until then... MySQLFront (Score:3, Informative)

    by carrowood ( 325102 ) on Wednesday January 21, 2004 @04:31PM (#8048161)
    Until then, I'll stick to MySQLFront [mysqlfront.de] (slow link). It does a pretty good job for windoze users. I do hope the new GUI is an open-source tool.
    • 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 [mysql.com]
      Health Monitor [mysql.com]
      Startup Parameters [mysql.com]
      Backup/Restore [mysql.com]

      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

    • <aol />

      I was going to suggest MySQLFront, but you beat me to it. :-)

      When I first started using MySQL a few years ago, I wanted to find a nice GUI front end for it, partly because relational databases are designed to hold tables of data, and I just think it's nicer to have that data presented as something looking like a spreadsheet application rather than ascii in a console. Sometimes, GUIs are just nicer tools, and for me this is one of those cases.

      More importantly, I wanted to set up the compa

      • MySQLFront is my choice as well. I've been using 2.4 for about 2 years and it still serves me well. Nice to see it's alive again and I hope it will live up to the old one if it is indeed a new app under the same name. Will check it out later today!

  • Backwards Compatiblity... (Score:3, Interesting)

    by OneFix at Work ( 684397 ) on Wednesday January 21, 2004 @05:35PM (#8049017)
    Will this product be backwards compatible with older versions of MySQL (3.x, 4.x, etc)...

    From the looks of it, this is either a replacement for Control Center or more than likely this will serve as the administrative package and Control Center will still server as a data entry and database design package...I don't actually see any table manipulation functions in this application...
    • If you're into Oracle, then a better comparison would be "Oracle Enterprise Manager".

      It's a tool to handle strict ADMIN things, such as user maintenance, creating schemas, etc.

      Control Center is a lot like SQL Navigator or Toad, which is a great tool for handling data or creating tables. But the admin functions are not as prevalent.
  • Database work: The dullest job in all of the computer industry.

    --Stephen
    • Database work: The dullest job in all of the computer industry.

      You've, obviously, never worked with a proper database. We don't need these rotten rows and columns, what's wrong with a hierarchical database. There is only one proper database - IBM's DL/I. And only one true implementation of DL/I in IBM's IMS [slashdot.org]. IMS gets you to, actually, work hard to create your database.

      Rows and columns, I spit on your rows and columns.
      Referential integrity - who needs RI, you get that for free with IMS.

      • I'm asleep already. I rest my case.
        The only interesting part about what you said is the design and implementation of a hierarchical database. And that's the only thing interesting about databases: creating the underlying structure, then the implementation. Everything else is the worst possible assignment I can possibly think of.

        --Stephen
  • Anybody have word on pricing for something like this? While MySQL might be a nice, free database server...the boys at MySQL.com have tried to turn a buck before on services and support, so I wouldn't be surprised if something like this actually costs money. Hopefully it's worth it.

    Until then, I'm stuck with ol' phpMyAdmin...

  • What escapes me is why there is no actual database access.

    pgadmin provides both the admin tools as well as database access.

    I would hate to have to use MySQL Admin and mysqlcc.

    -Jackson

  • Mascon?? (Score:3, Informative)

    by ajayrockrock ( 110281 ) on Wednesday January 21, 2004 @06:03PM (#8049361) Homepage
    The Windows users here at my work swear by Mascon [scibit.com]. It's 50 bucks and really cool. Makes my installation of phpMyAdmin [sf.net] 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

  • While your waiting... (Score:3, Informative)

    by agwis ( 690872 ) on Wednesday January 21, 2004 @06:10PM (#8049436)
    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 [www.minq.se] and phpMyAdmin [phpmyadmin.net] 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
  • ...why the hell do you need configurable icons for users in your DB admin tool?$#&*!

  • Why is it good? that's why. (Score:3, Interesting)

    by axxackall ( 579006 ) on Wednesday January 21, 2004 @07:33PM (#8050337) Homepage Journal
    For me, the best think about it is a competition. Look how Postgres guys immidiately begin to compare it to PgAdmin and other PostgreSQL DB admin tools (IMHO, which GUI are unfortunately really poor, by the way) - same as they usually do comparing MySQL to PostgreSQL (which DBMS is very good, by the way). What does it change for software? Developers on both sides are more motivated to make it better. What does it change for me? I have better databases and db tools. So, it's good.

    Look, guys, it's all about data management. The better GUI is the more complicated data can be managed. And that means more chances that MySQL developers will understand that in order to manage complicated data you have to have ACID. So, with MySQL v6 perhaps non-transactional updates will be more exception then a default rule.

    On the other side, the better GUI MySQL has got is the more motivation PostgreSQL guys will have to improve PgAdmin. So, the more chances that with PostgreSQL v8 we'll rarely hear here "Postgre... who?" The name will begin being recocognized not only by experts.

    On the other-other side (how many sides do I have?), I am thinking about better data-querying tool for ZODB. And MySQL GUI is a good source of good ideas.

  • DB Designer [fabforce.net] by FabForce.net is also an invaluable addition to any MySQL toolkit.
  • i saw mysql administrator at linuxworld in nyc yesterday, and it was freaking awesome. i got to ask a few questions of the guys there.

    it will be gpl'ed, and free for download. i can tell you that it touches virtually every administrative feature of mysql, and it looks very cool. was running very nicely, the realtime graphs are silky smooth, tho i didn't ask what hardware they were using for the administrator demo.

    they also said they plan on creating a similar tool, but this time for the sql query side, mo

    • The guy who started MySQLFront abandoned it, then turned around and let someone else [slashdot.org] pick up development. If it's still his project -- a big if? -- then maybe he'd be willing to let MySQL AB take it over.

      MySQLFront really is the best graphical MySQL interface available today. The only drawback -- and I admit that it's a big one -- is that it's currently only for Windows. If the application were given to MySQL AB, maybe they could flesh it out, port it to other platforms, and not have to start from scratch

  • http://www.ems-hitech.com/

    Disclaimer: I'm a happy (2nd year) customer, not an employee or other interested party.

    EMS HiTech has full GUI management systems for various databases. It's cross platform for windows and Linux.

    MS SQL Manager
    MySQL Manager
    PostgreSQL Manager
    InterBase / Firebird Manager
    DBISAM Manager

    They also do a suite of utilities for every day management of data across multiple servers. Again, mMost of these are cross-platform (Windows and Linux) with both GUI and CL
  • MythTV [mythtv.org]?
  • What framework/toolkit did MySQL use to build their new admin GUI?
    Anyone know?
  • For an 8-page list of MySQL administrators, check out MySQL's list [mysql.com].

    I've been using MySQL Command Center for a year and it works well. I don't like DHTML in phpMyAdmin. MySQL CC is quick and relatively well-designed, although the new MySQL Administrator screenshots look great.

  • Woohoo! (Score:1, Flamebait)

    by ttfkam ( 37064 )
    Now finally MySQL will look good on the client. Too damn bad all that GUI work is hobbled by such a crap datastore. I honestly wonder how the GUI will react to all of the silent "best guess" errors. ...must do a lot of data display refreshes.

    http://sql-info.de/mysql/gotchas.html [sql-info.de]

    It's like when Windows Millenium Edition was released. Sure it was pretty, but what lay beneath was atrocious.

Slashdot Top Deals

Put your Nose to the Grindstone! -- Amalgamated Plastic Surgeons and Toolmakers, Ltd.

Close