Kylin Server V10 下 MySQL 8 审计日志管理

一. 查看操作系统信息

[root@localhost ~]# cat /etc/.kyinfo 
[dist]
name=Kylin
milestone=Server-V10-GFB-Release-ZF9_01-2204-Build03
arch=arm64
beta=False
time=2023-01-09 11:04:36
dist_id=Kylin-Server-V10-GFB-Release-ZF9_01-2204-Build03-arm64-2023-01-09 11:04:36

[servicekey]
key=0080176

[os]
to=
term=2024-05-16
 

二、查看数据库信息

1 .查看数据库版本

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.3.0     |
+-----------+
1 row in set (0.00 sec)

2. 查看日志文件是否开启

mysql> show variables like 'general_log';
+--------------------+----------+
| Variable_name | Value  |
+--------------------+---------+
| general_log      |  ON     |
+--------------------+---------+
1 row in set (0.02 sec)
 

3. 查看日志文件位置

mysql> show variables like 'general_log_file';
+----------------------+----------------------------------------------+
| Variable_name    | Value