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."

7 of 25 comments (clear)

  1. 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.

  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 Anonymous Coward · · Score: 1, Informative

    They've been available since MySQL 4.1

    Wake up!

  5. 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
  6. 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.