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."
It's about bloody time. Shame it's only screencaps in the meantime. Oh, hey, FP! =^_^=
This sig no verb.
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.
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.)
I watched C-beams glitter in the dark near the Tannhauser gate.
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.
- tom -
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
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
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.
The GeekNights podcast is going strong. Listen!
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?
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
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, 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.
Sheeeet dawg joo best git wit it! Dems MSN ikonz are teh BOMBZZZZ!!!
Yah whutevah, you knows i be right foo'!! I PITY DA NOOB!!
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...
Database work: The dullest job in all of the computer industry.
--Stephen
Did you ever notice that *nix doesn't even cover Linux?
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...
-Barkeep, a draft of your most hazardous brew, for the world is slowly stepping into focus, and I don't like what I see.
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
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
...why the hell do you need configurable icons for users in your DB admin tool?$#&*!
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 !
...MySQL and other OpenSource databases need a front end that can be programmed in such a way as to add business logic. I think of Python or any other OO language here. Queries are not enough. For MySQL, interactive forms full with event driven procedures will be a resounding success when implemented. If I am going to design and code a DB for population tracking, it is neccessary to have the "Number of births" form widget disabled once the sex of an entry is selectd as male. This is because males are not expected to get pregnant. Hope my point is clear.
Cb..
I think I'll stick to SQLyog.
By "Linux" do they mean "GNU/Linux running on any platform", or do they mean "GNU/Linux running only on Intel i386 architecture"? If the former, then the app is probably source code and could be ported to BSD and then to Darwin.
DB Designer 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, more similar to mysql-front. i can't wait for that one either.
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 CLI.
I use the PostgreSQL manager. ( I use Enterprise Manager for my MSDE and SQL 7 ). It now supports PostgreSQL 7.4, and includes a visual designer, stored procedure debugger, report generators (HTML, PDF) and my FAVORITE new feature, integrated SSH tunnelling for the database connetion.
http://www.bullnet.com
The guy who started MySQLFront abandoned it, then turned around and let someone else 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 with their own new GUI client...
DO NOT LEAVE IT IS NOT REAL
MythTV?
. there used to be a sig here.....
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.
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.
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
It's like when Windows Millenium Edition was released. Sure it was pretty, but what lay beneath was atrocious.
- I don't need to go outside, my CRT tan'll do me just fine.