MySQL Audit Events

MySQL audit events can include events such as BINLOG, CHANGE, and CONNECT,

This audit event names used in MySQL to their equivalent values in the command_class and target_type fields in the audit record. You can use the audit events mapped here to create custom audit reports using other Oracle Database reporting products or third-party tools.

See Also: Database Schemas for data warehouse details that may be useful in designing your own reports.

Table 1 lists the MySQL audit events and the equivalent events.

Table 1 MySQL Audit Events

Source Event	Command Class	Target Type
AUDIT	AUDIT	SYSTEM
BINLOG DUMP	DUMP	TRACE
CHANGE USER	UPDATE	USER
CLOSE STMT	CLOSE	STATEMENT
CONNECT OUT	DISCONNECT	SYSTEM
CONNECT	CONNECT	SYSTEM or DATABASE
CREATE DB	CREATE	DATABASE
DAEMON	EXECUTE	DAEMON
DEBUG	ENABLE	DEBUG
DELAYED INSERT	INSERT	TABLE
DROP DB	DROP	DATABASE
EXECUTE	EXECUTE	STATEMENT
FETCH	RETRIEVE	TABLE
FIELD LIST	RETRIEVE	PROPERTY
INIT DB	INITIALIZE	DATABASE
KILL	KILL	CONNECTION or QUERY
LONG DATA	EXECUTE	STATEMENT
NOAUDIT	NOAUDIT	SYSTEM
PING	CONNECT	SYSTEM
PREPARE	INITIALIZE	STATEMENT
PROCESSLIST	RETRIEVE	PROCESS
QUERY	EXECUTE	STATEMENT
QUIT	DISCONNECT	SYSTEM
REFRESH	REFRESH	SYSTEM
REGISTER REPLICA	REGISTER	SYSTEM
RESET STMT	RESET	STATEMENT
SET OPTION	SET	VARIABLE
SHUTDOWN	SHUTDOWN	SYSTEM
SLEEP	SLEEP	CONNECTION
STATISTICS	RETRIEVE	STATISTICS
TABLE DUMP	DUMP	TABLE
TIME	RETRIEVE	TIME
ADMIN_COMMANDS	EXECUTE	COMMAND
ASSIGN_TO_KEYCACHE	ASSIGN	TABLE
ALTER_DB	ALTER	DATABASE
ALTER_DB_UPGRADE	UPDATE	DATABASE
ALTER_EVENT	ALTER	EVENT
ALTER_FUNCTION	ALTER	FUNCTION
ALTER_INSTANCE	ALTER	INSTANCE
ALTER_PROCEDURE	ALTER	PROCEDURE
ALTER_SERVER	ALTER	SERVER
ALTER_TABLE	ALTER	TABLE
ALTER_TABLESPACE	ALTER	TABLESPACE
ALTER_USER	ALTER	USER
ANALYZE	ANALYZE	TABLE
BEGIN	START	TRANSACTION
BINLOG	WRITE	TRACE
CALL_PROCEDURE	EXECUTE	PROCEDURE
CHANGE_DB	UPDATE	DATABASE
CHANGE_MASTER	UPDATE	SYSTEM
CHANGE_REPL_FILTER	UPDATE	FILTER
CHECK	VALIDATE	TABLE
CHECKSUM	VALIDATE	TABLE
COMMIT	COMMIT	TRANSACTION
CREATE_DB	CREATE	DATABASE
CREATE_EVENT	CREATE	EVENT
CREATE_FUNCTION	CREATE	FUNCTION
CREATE_INDEX	CREATE	INDEX
CREATE_PROCEDURE	CREATE	PROCEDURE
CREATE_SERVER	CREATE	SERVER
CREATE_TABLE	CREATE	TABLE
CREATE_TRIGGER	CREATE	TRIGGER
CREATE_UDF	CREATE	FUNCTION
CREATE_USER	CREATE	USER
CREATE_VIEW	CREATE	VIEW
DEALLOC_SQL	DROP	STATEMENT
DELETE	DELETE	TABLE
DELETE_MULTI	DELETE	TABLE
DO	EXECUTE	EXPRESSION
DROP_DB	DROP	DATABASE
DROP_EVENT	DROP	EVENT
DROP_FUNCTION	DROP	FUNCTION
DROP_INDEX	DROP	INDEX
DROP_PROCEDURE	DROP	PROCEDURE
DROP_SERVER	DROP	SERVER
DROP_TABLE	DROP	TABLE
DROP_TRIGGER	DROP	TRIGGER
DROP_USER	DROP	USER
DROP_VIEW	DROP	VIEW
EMPTY_QUERY	EXECUTE	STATEMENT
EXECUTE_SQL	EXECUTE	STATEMENT
EXPLAIN_OTHER	RETRIEVE	TABLE
FLUSH	FLUSH	TABLE or null
GET_DIAGNOSTICS	RETRIEVE	TRACE
GRANT	GRANT	PRIVILEGE
HA_CLOSE	CLOSE	TABLE
HA_OPEN	OPEN	TABLE
HA_READ	READ	TABLE
HELP	GET	SUMMARY
INSERT	INSERT	TABLE
INSERT_SELECT	INSERT	TABLE
INSTALL_PLUGIN	INSTALL	PLUGIN
LOAD	LOAD	TABLE
LOCK_TABLES	LOCK	TABLE
OPTIMIZE	OPTIMIZE	TABLE
PRELOAD_KEYS	LOAD	TABLE
PREPARE_SQL	INITIALIZE	STATEMENT
PURGE	DROP	TRACE
PURGE_BEFORE_DATE	DROP	TRACE
RELEASE_SAVEPOINT	RELEASE	SAVEPOINT
RENAME_TABLE	RENAME	TABLE
RENAME_USER	RENAME	USER
REPAIR	REFRESH	TABLE
REPLACE	REPLACE	TABLE
REPLACE_SELECT	REPLACE	TABLE
RESET	RESET	TRACE
RESIGNAL	NOTIFY	SIGNAL
REVOKE	REVOKE	PRIVILEGE
REVOKE_ALL	REVOKE	PRIVILEGE
ROLLBACK	ROLLBACK	TRANSACTION
ROLLBACK_TO_SAVEPOINT	ROLLBACK	SAVEPOINT
SAVEPOINT	SET	SAVEPOINT
SELECT	SELECT	TABLE
SET_OPTION	SET	VARIABLE
SIGNAL	NOTIFY	SIGNAL
SHOW_BINLOG_EVENTS	RETRIEVE	EVENT
SHOW_BINLOGS	RETRIEVE	TRACE
SHOW_CHARSETS	RETRIEVE	PROPERTY
SHOW_COLLATIONS	RETRIEVE	PROPERTY
SHOW_CREATE_DB	RETRIEVE	STATEMENT
SHOW_CREATE_EVENT	RETRIEVE	STATEMENT
SHOW_CREATE_FUNC	RETRIEVE	STATEMENT
SHOW_CREATE_PROC	RETRIEVE	STATEMENT
SHOW_CREATE_TABLE	RETRIEVE	STATEMENT
SHOW_CREATE_TRIGGER	RETRIEVE	STATEMENT
SHOW_DATABASES	RETRIEVE	DATABASE
SHOW_ENGINE_LOGS	RETRIEVE	TRACE
SHOW_ENGINE_MUTEX	RETRIEVE	MUTEX
SHOW_ENGINE_STATUS	RETRIEVE	STATUS
SHOW_EVENTS	RETRIEVE	DATABASE
SHOW_ERRORS	RETRIEVE	ERROR
SHOW_FIELDS	DESCRIBE	TABLE
SHOW_FUNCTION_CODE	RETRIEVE	FUNCTION
SHOW_FUNCTION_STATUS	RETRIEVE	STATUS
SHOW_GRANTS	RETRIEVE	USER
SHOW_KEYS	RETRIEVE	TABLE
SHOW_MASTER_STATUS	RETRIEVE	STATUS
SHOW_OPEN_TABLES	RETRIEVE	DATABASE
SHOW_PLUGINS	RETRIEVE	PLUGIN
SHOW_PRIVILEGES	RETRIEVE	PRIVILEGE
SHOW_PROCEDURE_CODE	RETRIEVE	PROCEDURE
SHOW_PROCEDURE_STATUS	RETRIEVE	STATUS
SHOW_PROCESSLIST	RETRIEVE	PROCESS
SHOW_PROFILE	RETRIEVE	QUERY
SHOW_PROFILES	RETRIEVE	PROFILE
SHOW_RELAYLOG_EVENTS	RETRIEVE	EVENT
SHOW_REPLICA_HOSTS	RETRIEVE	REPLICA
SHOW_REPLICA_STATUS	RETRIEVE	STATUS
SHOW_STATUS	RETRIEVE	STATUS
SHOW_STORAGE_ENGINES	RETRIEVE	PROPERTY
SHOW_TABLE_STATUS	RETRIEVE	DATABASE
SHOW_TABLES	RETRIEVE	DATABASE
SHOW_TRIGGERS	RETRIEVE	DATABASE
SHOW_VARIABLES	RETRIEVE	VARIABLE
SHOW_WARNINGS	RETRIEVE	WARNING
SHOW_CREATE_USER	RETRIEVE	STATEMENT
REPLICA_START	START	SYSTEM
REPLICA_STOP	STOP	SYSTEM
GROUP_REPLICATION_START	START	REPLICATION
GROUP_REPLICATION_STOP	STOP	REPLICATION
STMT_EXECUTE	EXECUTE	STATEMENT
STMT_CLOSE	CLOSE	STATEMENT
STMT_FETCH	GET	STATEMENT
STMT_PREPARE	INITIALIZE	STATEMENT
STMT_RESET	RESET	STATEMENT
STMT_SEND_LONG_DATA	SEND	STATEMENT
TRUNCATE	TRUNCATE	TABLE
UNINSTALL_PLUGIN	UNINSTALL	PLUGIN
UNLOCK_TABLES	UNLOCK	TABLE
UPDATE	UPDATE	TABLE
UPDATE_MULTI	UPDATE	TABLE
XA_COMMIT	COMMIT	XA
XA_END	STOP	XA
XA_PREPARE	INITIALIZE	XA
XA_RECOVER	RECOVER	XA
XA_ROLLBACK	ROLLBACK	XA
XA_START	START	XA