MySQL Administrator v1.0.1a-Alpha Released

← Back to Stories (view on slashdot.org)

MySQL Administrator v1.0.1a-Alpha Released

Posted by simoniker on Wednesday February 11, 2004 @06:42PM from the point-seven-zeta-reticuli dept.

OnBeyondBeing writes "'MySQL Administrator is a powerful new visual administration console that lets you easily administer your MySQL environment and gain better visibility into how your databases are operating. This is the first alpha release. The source code and binaries for Linux and Microsoft Windows XP/2000/NT are now available for download."

25 comments

Min score:

Reason:

Sort:

Color Me Crazy, But... by thecampbeln · 2004-02-11 18:51 · Score: 2, Insightful

Wouldn't it have been better for MySQL to lend the development work used to create this GUI to expand the capabilities of phpMyAdmin? Now granted, phpMyAdmin requires PHP (and by proxy a web server, as well as a web browser come to think of it) to run, but it runs on any platform that supports PHP. Seems to me that this is the best approach for Db admin (well, for my server at least).
Or am I missing the point? Is there any reason to have a thin/thick client over a web client?
PS - I'm downloading the alpha so I can give it a try, so maybe I'll get it ;)

--
"1984" was ment to be a warning, not a guidebook. You hear that Kim Jong-il!? BushCo?!
1. Re:Color Me Crazy, But... by johnjosephbachir · 2004-02-11 19:04 · Score: 1
  
  I was just going to raise this same point. Of course I am guessing that there must be some features that phpMyAdmin doesn't have... I hope independence from php wasn't a main motivation of the project.
  
  That said, can anyone give us a quick and dirty feature comparison of the two tools?
  
  John
2. Re:Color Me Crazy, But... by TekZen · 2004-02-11 19:08 · Score: 5, Interesting
  
  I currently use mysqlcc and phpMyAdmin.
  
  The main difference is in the server admin functionality not the actual data management.
  
  For instance, when something seems a little slow I start watching the mysql process list using mysqlcc. I set it to refresh every 5 seconds (but I could set it lower). That is the kind of thing you can not do with phpMyAdmin (last time I checked).
  
  -Jackson
3. Re:Color Me Crazy, But... by natmsincome.com · 2004-02-11 19:14 · Score: 2, Informative
  
  phpMyAdmin is great for when your managing a server remotely or on a server with a webserver but if you don't have a webserver it's alot of work to install a webserver then php then libphpmysql then phpMyAdmin just to admin a database. Also web interfaces just aren't the same as a interactive interface. All that being said I'll keep using phpMyAdmin most of the time but it's nice to know that I don't need one if I have an app that just needs MySQL.
4. Re:Color Me Crazy, But... by caseih · 2004-02-11 19:32 · Score: 5, Insightful
  
  The MySQL Administrator has nothing to do with phpMyAdmin. In fact it doesn't even have the same function. The MySQL Administrator is intended as a tool to administer the servers themselves, not the data that's in them (except to make backups, etc). This functionality will go a long ways to convincing PHB's who have a natural fear of anything that's not windows and not graphical that MySQL can be deployed and administered successfully within their enterprise. Everything from tuning the server engine itself to backups can be done from a comfortable console. Even to experienced Unix admins, this is a great tool.
  
  Let us know how your trial run goes.
5. Re:Color Me Crazy, But... by treerex · 2004-02-12 11:01 · Score: 1
  
  For instance, when something seems a little slow I start watching the mysql process list using mysqlcc. I set it to refresh every 5 seconds (but I could set it lower). That is the kind of thing you can not do with phpMyAdmin[...]
  
  You cannot get the auto-refresh, but you can view the process list from phpMyAdmin and kill processes, assuming your permissions allow it.
MacOS X port? by Gogo+Dodo · 2004-02-11 19:18 · Score: 1

Has anybody heard any news about a MacOS X port?
1. Re:MacOS X port? by krow · 2004-02-11 19:42 · Score: 1
  
  Expect one a little later this year.
  
  --
  You can't grep a dead tree.
Alpha is right by Bitsy+Boffin · 2004-02-11 19:23 · Score: 5, Informative

Just had a cursory look through it, and I think alpha is the right word, doesn't seem to be feature complete and there are numerous little things that need fixing.

The interface looks purty, but it's a bit unintuitive. For example, I would have expected a way to be able to manage multiple servers at the same time, there appears to be no way to delete backup profiles, the fact that users are grouped by the username is not obvious (click a user with multiple hosts and an expansion arrow will appear allowing you then to expand it out to see the hosts), it's not obvious that a user has no permissions (the permissions tab is just disabled). You can't resize some panes (eg looking at a 'Catalog' (huh? Database is the term) you can't make the list of tables longer and the tabset smaller (easy fix in glade though), the view menu is completely redundant, the Edit menu options don't work (on Backup profiles at least, havn't checked the others). Some things are mis-labelled (eg apparently the 'Performance' tab of Startup Variables is for managing log files).

It also requires to be installed in /opt (hard coded in the binary), I guess if you want it somewhere else you have to compile yourself.

But those are all minor things, one glaring ommission though is there is no way to manage the data, or structure of databases - you can see all the structure but can't actually do anything with it, and can't even run an SQL statement against it - maybe it's coming.

It'll take them some work, but it's a good looking start anyway.

--
NZ Electronics Enthusiasts: Check out my Trade Me Listings
1. Re:Alpha is right by krow · 2004-02-11 19:40 · Score: 2, Informative
  
  Admin is just the first tool to be released (more to come this year). So, expect to see some of the features you are asking to be coming in additional tools later this year.
  
  --
  You can't grep a dead tree.
2. Re:Alpha is right by Anonymous Coward · 2004-02-12 03:57 · Score: 0
  
  It also requires to be installed in /opt (hard coded in the binary), I guess if you want it somewhere else you have to compile yourself.
  I know I'm nitpicking, but /opt is a standard place to put binary packages on most Linux distros. There's nothing wrong or unusual about this software package in that respect.
3. Re:Alpha is right by justMichael · 2004-02-13 10:39 · Score: 1
  
  one glaring ommission though is there is no way to manage the data, or structure of databases - you can see all the structure but can't actually do anything with it, and can't even run an SQL statement against it
  
  Sounds like you want MySQLCC or if you are an OS X user, you want this one (warning: direct link the .dmg).
MySQL Front by vskjefst · 2004-02-11 20:06 · Score: 4, Informative

I'd like to recommend MySQL-Front. Great piece of software.

--
Vegard
1. Re:MySQL Front by Phillup · 2004-02-12 04:30 · Score: 1
  
  All I could find was versions for Windows.
  
  Thanks, but I'll pass.
  
  --
  
  --Phillip
  
  Can you say BIRTH TAX
2. Re:MySQL Front by Richard_at_work · 2004-02-12 11:06 · Score: 1
  
  I use MysqlFront extensively, but only the old codebase. I cannot get used to the new codebase, its just not as good as the old one. I wish the bloke would release the code, anyone know why he chose not to?
3. Re:MySQL Front by justMichael · 2004-02-13 10:43 · Score: 1
  
  I wish the bloke would release the code, anyone know why he chose not to?
  
  He would have a hard time collecting the $25 shareware fee if you could build your own ;-)
4. Re:MySQL Front by Richard_at_work · 2004-02-13 11:50 · Score: 1
  
  The older codebase is not the same base for the 3.0 or current code base. He stopped development suddendly around v2.5 citing personal issues and left a load of people hanging. Thus the current 3.0 codebase only follows the older MysqlFront in name, and not anything that matters. The new codebase sucks in more than one way.
CocoaMySQL by elliotj · 2004-02-12 02:27 · Score: 1

Try CocoaMySQL if you're looking for an OS X GUI. It's great.

Get it here.
Now if only MySQL had subqueries by xutopia · 2004-02-12 02:57 · Score: 1, Insightful

cause I sure as hell would like to see them!
1. Re:Now if only MySQL had subqueries by Anonymous Coward · 2004-02-12 03:50 · Score: 1, Informative
  
  They've been available since MySQL 4.1
  
  Wake up!
2. Re:Now if only MySQL had subqueries by Martin+Blank · 2004-02-12 04:36 · Score: 1
  
  ...which is not a release package.
  
  --
  You can never go home again... but I guess you can shop there.
3. Re:Now if only MySQL had subqueries by tcopeland · 2004-02-12 05:12 · Score: 3, Informative
  
  From here:
  
  Subqueries allow you to use the result of one query as a component of a larger query. The MySQL server already supports some forms of this technique, such as INSERT INTO ... SELECT ..., and this support will be expanded in version 4.1 to include nested SELECT queries, which is one of the most-requested features from our users.
  
  Almost there...
  
  --
  The Army reading list
what about postgresql by treat · 2004-02-12 10:49 · Score: 0, Insightful

Is there any decent GUI for PostgreSQL? It seems that I'm left with a choice between using a real database that has no GUI, and using a crappy database with a decent GUI.
1. Re:what about postgresql by Cajal · 2004-02-12 13:32 · Score: 2, Informative
  
  Check out pgAdmin III - http://www.pgadmin.org/pgadmin3/index.php
  
  It's a very nice, cross-platform GUI for PG.