To successfully uninstall the DAM audit plug-in, set the
audit_uninstall_plugin=1 parameter in the
/etc/my.cnf file, and then install the audit plug-in.
NOTES:
- In this example, the plug-in is named AUDIT, which is the usual name for the plug-in. But the name is definable by the administrator during installation or loading.
- Make sure the account that you use to make these changes offers sufficient editing and saving rights.
If you have not set the above parameter before audit plug-in installation, uninstall the audit plug-in manually:
- Open /etc/my.cnf in a text editor.
- Locate the [mysqld] entry.
- Underneath the entry, add the parameter audit_uninstall_plugin=1
- Save your changes.
- Stop the mysqld daemon service:
Type /etc/init.d/mysqld stop and press Enter.
- Start the mysqld daemon service:
Type /etc/init.d/mysqld start and press Enter.
- At the MySQL prompt, type show plugins; and press Enter.
- If you see the following output, continue:
+----------------------------+----------+--------------------+--------------------+---------+
| Name | Status | Type | Library | License |
+----------------------------+----------+--------------------+--------------------+---------+
| AUDIT | ACTIVE | AUDIT | libaudit_plugin.so | GPL |
+----------------------------+----------+--------------------+--------------------+---------+
- Here the name of the plug-in is AUDIT as seen in the Name column. If the plug-in is named, for example McAfee or Trellix, execute the commands using that name as appropriate.
- Confirm that you can remove the plug-in.
In the MySQL prompt, type show global variables like '%audit_uninstall_plugin%'; and press Enter:
- If you see the following output, continue:
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| audit_uninstall_plugin | ON |
+------------------------+-------+
- If you don't see this output, create a Service Request.
- If you are a registered user, type your User ID and Password, and then click Log In.
- If you are not a registered user, click Register and complete the fields. Your password and instructions are emailed to you.
- Log on to the MySQL shell:
Type mysql -u root -p and press Enter.
- Uninstall the plug-in:
- Type UNINSTALL PLUGIN AUDIT; and press Enter.
You see the output:
ERROR 1620 (HY000): Uninstall AUDIT plugin must be called again to complete
This output is expected.
- Type UNINSTALL PLUGIN AUDIT; and press Enter.
This time, you see a prompt that the query was executed successfully: Query OK, 0 rows affected (0.00 sec).
- Check that the plug-in has been uninstalled:
Type show plugins; and press Enter.
You see that the table no longer displays the DAM audit plug-in.
