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 (OCA) 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

[28 May 2010 21:17] Roel Van de Paar
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.
[28 May 2010 21:30] Roel Van de Paar
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 |
+-------+-----------+
[3 Jun 2010 18:23] Enterprise Tools JIRA Robot
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.
[7 Jun 2010 17:20] BitRock Merlin
The uninstaller does not support a custom screen currently but we can add a pop-up asking for the password.