Slashdot Mirror

← Back to Stories (view on slashdot.org)

MySQL Administrator v1.0.1a-Alpha Released

Posted by simoniker on 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."

9 of 25 comments (clear)

  1. Color Me Crazy, But... by thecampbeln · · 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 TekZen · · 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

    2. Re:Color Me Crazy, But... by natmsincome.com · · 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.

    3. Re:Color Me Crazy, But... by caseih · · 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.

  2. Alpha is right by Bitsy+Boffin · · 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 · · 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.
  3. MySQL Front by vskjefst · · Score: 4, Informative

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

    --
    Vegard
  4. Re:Now if only MySQL had subqueries by tcopeland · · 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
  5. Re:what about postgresql by Cajal · · Score: 2, Informative

    Check out pgAdmin III - http://www.pgadmin.org/pgadmin3/index.php

    It's a very nice, cross-platform GUI for PG.