I tried to read the Audit.log file of the MySQL Enterprise using a table or other more friendly format and easy to access and understand, but the xml format with which it is written has an irregular structure:
2019-02-17T12:53:23 UTC
1_2019-02-17T12:53:23
Audit
1
1
./mysqld --basedir=/MYSQL_HOME/mysql
x86_64-linux-glibc2.12
5.6.38-enterprise-commercial-advanced-log
2019-02-19T02:22:23 UTC
2_2019-02-17T12:53:23
Connect
460432
0
0
nbryan
172.17.3.150
connect
nbryan
2019-02-19T02:22:23 UTC
3_2019-02-17T12:53:23
Query
460432
0
0
flopez[nbryan] @ [172.17.3.150]
172.17.3.150
set_option
/*!40101 set @@session.wait_timeout=28800 */
As you can see, the same tags are not always generated, so I have not been able to format it to a table from the SQL Server (there is a lot of information on how to read xml formats using sql). I wanted to know if there is another way, maybe from the same MySQL, although it is very difficult to find something of this manager in relation to other solutions.
Any help or idea would be very helpful.
Thank you.
Asked by Fran.J
(121 rep)
Mar 7, 2019, 02:15 PM
Last activity: Aug 9, 2025, 07:08 PM
Last activity: Aug 9, 2025, 07:08 PM