RE: gui-tool?

Sam & Brandon,

I have to agree with you both.   I use the MySQL Administrator and for
some things it works okay, but certain functions are definitely
unstable.   The User Account portion of this tool is particularly evil!
I've used it to create or modify user accounts (add/remove host entries
from a user) and have some really bad things happen with no explanation
or error message from the tool.   The user list does not change unless
you manually tell it to refresh.   The "clone user" feature seems to be
particularly dangerous to use.  Its crashed on me several times (I gave
up on it).   Until they fix this, I'm using other methods to
create/modify accounts.

However, I really do love the System Health, Session monitors and schema
mgmt in MySQL Administrator - most other tools aren't as nice in this
area.   

Both Navicat and SQLyog are pretty nice Admin GUI's, though each of
these 3 tools has their strong features, but then has some lame ones.

If only MySQL would just fix the bugs and add some more features that
the competition has, then it would be a great tool.

David K. Whisler
Oracle & MySQL Database Adminstrator & Developer
The William States Lee College of Engineering
UNC Charlotte


-----Original Message-----
From: Brandon Whitehead [mailto:[email protected]] 
Sent: Friday, January 09, 2009 3:40 PM
To: Just E. Mail
Cc: [email protected]
Subject: Re: gui-tool?

Sam,

You are not alone.

I've been using the GUI tools for quite some time, and I find them to  
be unstable at best. (Sorry MySQL guys.) Specifically, they crash a  
lot for no apparent reason on my Mac.  I've tried multiple versions of  
the tools on multiple version of MacOS.  I'm not exactly sure of the  
problem, but generally the applications quit unexpectedly. Thus, I use  
them with a large grain of salt and the general expectation that they  
will crash when its most inconvenient. In addition, the usability is  
limited by inconsistent rendering of SQL in Administrator and the  
omission of basic clipboard copy functionality of the results pane in  
Query Browser.

That said, given MySQLs OSS roots, I think most long term users use  
the tools from the command line, which is almost perfectly reliable.   
If my memory serves me, MySQL/Sun have recently made it easier to  
engage community involvement in the development of the tools, and I  
would expect that to help.

In the meantime, you can use Navicat, which is inexpensive, or become  
more well versed at the command line.  If I recall, there may also be  
some plug-in capabilities for Eclipse.

Best Regards,

Brandon K. Whitehead
University of Washington

On Jan 9, 2009, at 11:23 AM, Just E. Mail wrote:

> Hello:
>
> I am not trying to offend anybody. Please read and help me.
>
> I have a new CentOS 5.2 installation with MySQL 5.1 and Gui- 
> Tools5.1. I
> have tried to setup a test table using Gui-Tools. It seems that the
> Gui-Tools documentation is too little and the screen shots do not  
> match
> with the written documentation. This leaves me with the following  
> choices:
>
> 1. Consult MySQL 5.1 documentation and setup table manually (it is
> difficult because this is my first encounter with MySQL;
> 2. Look for other documentation/samples/tutorials for Gui-Tools! For
> this recommendation I need some direction pointing me towards these
> documents/samples/tutorials;
> 3. Try Navicat (except I have no money to spend).
> 4. Try PostgreSQL & hope that they have better GUI tools.
>
> Please help. Send me a direct email if you want to reply to me  
> directly.
> I have already spent 2-3 weeks on this problem.
>
> Thanks in advance.
>
> Sam
>
>
> -- 
> MySQL GUI Tools Mailing List
> For list archives: http://lists.mysql.com/gui-tools
> To unsubscribe:
http://lists.mysql.com/[email protected]
>


-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:
http://lists.mysql.com/[email protected]


-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]