Slashdot Mirror
MySQL Official GUI Interface
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."
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.
This sounds like a pretty sweet tool
mmmmm... sweet, GUI tool.
-----
P. Hilton
Best Windows Freeware
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.
(Spudley Strikes Again!)
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.
Is here
US Democracy:The best person for the job (among These pre-selected choices...)
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
-gbd
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
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.
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.
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...
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 want half a dozen screenshots for a mythical product, give me half a day I'll create the phony GUI using Delphi or Visual Studio. Which, come to think of it, is almost certainly what they did. Why else no Linux screenshots? If they had them, they'd certainly show them, given the Linux bias of the typical MySQL user.
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
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
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.
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.
Less is more !
DB Designer by FabForce.net is also an invaluable addition to any MySQL toolkit.