Log Entry Schema for LOGINS-ONLY Level
If your node is configured to use the LOGINS-ONLY logging mode, the log entry uses the following schema:
<log-entry-id>,<timestamp>,<time-zone>,<hostname>:<port>,<node-type>,USER_LOGIN,<thread-id>,<username>,<remote-host>,<user-grant>,<auth-type>,<success or failure>:<reason>
Note: Login data and the database activity can coexist in one file.
The following log entry uses the schema specified above, and it represents a user pac with a successful login attempt:
3,2020-08-11 18:53:18.150,UTC,c770dd909a9c:3306,agg,USER_LOGIN,100000,pac,192.168.0.1,pac@%,mysql_native_password,SUCCESS
The following table describes the fields in the schema, and identifies each of the values in the example above:
Entry | Description | Example Value |
|---|---|---|
| Represents the log entry’s unique identifier. | 3 |
| The node’s local system time when an operation was executed. | 2020-08-11 18:53:18.150 |
| Specifies the local time zone when an operation was executed. | UTC |
| Specifies the node’s hostname and port. | c770dd909a9c:3306 |
| Specifies whether the node is an | agg |
| A constant which indicates that the record format represents a user login. | USER_LOGIN |
| Id of the thread executing the statement. | 100000 |
| Specifies the username that is trying to log in. | pac |
| Hostname/address from which the client is connecting. This value is detected by the server and not reported by the client. | 192.168.0.1 |
| The | pac@% |
| Indicates the authentication method which is active (for example native password, pam, Kerberos, etc.), as specified by the | mysql_native_password |
| Indicates the success or failure of the login attempt. The | SUCCESS |
For more information on common log entries, see the General Log Entry Schema section above.