Follow Slashdot blog updates by subscribing to our blog RSS feed

 



Forgot your password?
typodupeerror
×
Announcements Software

MySQL Administrator v1.0.1a-Alpha Released 25

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."
This discussion has been archived. No new comments can be posted.

MySQL Administrator v1.0.1a-Alpha Released

Comments Filter:
  • Wouldn't it have been better for MySQL to lend the development work used to create this GUI to expand the capabilities of phpMyAdmin [phpmyadmin.net]? 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

    • 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
    • by TekZen ( 611640 ) on Thursday February 12, 2004 @03:08AM (#8256060) Homepage Journal
      I currently use mysqlcc [mysql.com] 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
      • 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.

    • 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.
    • by caseih ( 160668 ) on Thursday February 12, 2004 @03:32AM (#8256141)
      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.
  • Has anybody heard any news about a MacOS X port?
  • Alpha is right (Score:5, Informative)

    by Bitsy Boffin ( 110334 ) on Thursday February 12, 2004 @03:23AM (#8256114) Homepage
    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.
    • Re:Alpha is right (Score:3, Informative)

      by krow ( 129804 ) *
      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.
    • 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 [mysql.com] or if you are an OS X user, you want this one [pogma.com] (warning: direct link the .dmg).

  • MySQL Front (Score:4, Informative)

    by vskjefst ( 455144 ) on Thursday February 12, 2004 @04:06AM (#8256253) Homepage
    I'd like to recommend MySQL-Front [mysqlfront.de]. Great piece of software.
    • All I could find was versions for Windows.

      Thanks, but I'll pass.
    • 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?
      • 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 ;-)
        • 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.
  • cause I sure as hell would like to see them!

Happiness is twin floppies.

Working...