MySQL Bugs: #54074: Uninstalling MySQL Enterprise Monitor agent does not remove assigned GRANTS

Bug #54074	Uninstalling MySQL Enterprise Monitor agent does not remove assigned GRANTS
Submitted:	28 May 2010 21:17	Modified:	28 May 2010 21:30
Reporter:	Roel Van de Paar	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor: Installing	Severity:	S3 (Non-critical)
Version:	2.2.0.1705	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
When the MySQL Enterprise Monitor agent is uninstalled, it does not revoke the assigned GRANTs on the monitored MySQL server.

How to repeat:
Install agent, uninstall agent, check GRANTs.

Suggested fix:
Best option: have a screen in the un-installation process similar to the screen in the installation process that asks for root or similar credentials to go ahead and remove the userid.

Verified by reinstall/uninstall on same machine.

mysql> select user,host from mysql.user where user='agent';
+-------+-----------+
| user  | host      |
+-------+-----------+
| agent | %         |
| agent | localhost |
+-------+-----------+
mysql> /* uninstall agent */
mysql> select user,host from mysql.user where user='agent';
+-------+-----------+
| user  | host      |
+-------+-----------+
| agent | %         |
| agent | localhost |
+-------+-----------+

Andy Bang writes: 
Can we add a screen to the Agent uninstaller that prompts the user asking whether they want the credentials removed, and if so, for the required login credentials to do so? Note that customers can (and do) use pre-existing credentials associated with other purposes, so  we cannot assume that the is to be deleted because it may be used by others, so we must prompt first.

The uninstaller does not support a custom screen currently but we can add a pop-up asking for the password.