Bug #20183 Remove User kills account without warning
Submitted: 1 Jun 2006 1:44 Modified: 19 Jun 2006 9:15
Reporter: Vivek Basrur Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:5.0 OS:MacOS (Mac OS X)
Assigned to: Domas Mituzas CPU Architecture:Any

[1 Jun 2006 1:44] Vivek Basrur
Description:
I am new to MySQL. So far very impressed with Windows version. However, on the Mac OS X version, which also looks very good, there is a very serious problem -- in the Accounts view, you can REMOVE a user accidentally (and permanently). THERE IS NO WARNING or "Are you sure?" protection. I am reporting this as a bug because I cannot believe it is by design. (In the Windows version, such an "Are you sure?" protection is correctly implemented, at least for removing a user but, unfortunately, not for removing a host.)

How to repeat:
STEP 1: Create a dummy account (one you can afford to lose!)
------------------------------------------------------------
Start MySQL Administrator and login as expected
Select the Accounts view
Add a user, e.g., JaneDoe@localhost
Quit MySQL Administrator 

STEP 2: Remove the dummy account (one you can afford to lose!)
---------------------------------------------------------------
Start MySQL Administrator and login as expected
Select the Accounts view
Remove the user added above, e.g., JaneDoe@localhost
NOTICE: Without allowing the administrator to confirm, the Account List is immediately updated and the user is GONE!

Suggested fix:
AT A MINIMUM:
Make it work like the Windows version. Before removing the account, ask the user to confirm with an appropriate Mac-like prompt. Remove the user only if the user says "Yes"

DO IT BETTER THAN THE WINDOWS VERSION:
Provide the same safety net when removing Host.

EVEN BETTER:
In the MySQL Preferences pane, add a check box (checked by default) that looks something like this:
  [X] Always confirm before removing USER from Account list
  [X] Always confirm before removing HOST from Account list
Admins who like to fly without the safety net (and they shouldn't be admins) can uncheck the options and have it work it does now!
[1 Jun 2006 4:33] Valeriy Kravchuk
Thank you for a problem report. Please, specify exact version of MySQL Administrator used. 

We have QB for Mac OS X (see http://dev.mysql.com/downloads/query-browser/1.1.html), PowerPC.
[19 Jun 2006 9:15] Domas Mituzas
Could not reproduce with 1.1.10, which is Universal (+x86) binary too.