### FINAL MYSQL56 EVIDENCE 2026-07-31T09:48:54+08:00
## OS
NAME="openEuler"
VERSION="24.03 (LTS)"
ID="openEuler"
VERSION_ID="24.03"
PRETTY_NAME="openEuler 24.03 (LTS)"
ANSI_COLOR="0;31"
## package residue
mysql-selinux-1.0.10-1.oe2403.noarch
## binary version
/usr/local/mysql/bin/mysql  Ver 14.14 Distrib 5.6.51, for linux-glibc2.12 (x86_64) using  EditLine wrapper
/usr/local/mysql/bin/mysqld  Ver 5.6.51 for linux-glibc2.12 on x86_64 (MySQL Community Server (GPL))
## service
active
enabled
● mysql.service - MySQL Community Server
     Loaded: loaded (/etc/systemd/system/mysql.service; enabled; preset: disabled)
     Active: active (running) since Fri 2026-07-31 09:46:01 CST; 2min 52s ago
    Process: 16433 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
   Main PID: 16449 (mysqld_safe)
      Tasks: 23 (limit: 46858)
     Memory: 662.0M ()
     CGroup: /system.slice/mysql.service
             ├─16449 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/workspace/mysql/data --pid-file=/workspace/mysql/mysql.pid
             └─16869 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/workspace/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/workspace/mysql/log/mysql-error.log --open-files-limit=65535 --pid-file=/workspace/mysql/mysql.pid --socket=/tmp/mysql.sock --port=3306

Jul 31 09:46:00 sfd-db systemd[1]: Starting MySQL Community Server...
Jul 31 09:46:01 sfd-db mysql[16433]: Starting MySQL. SUCCESS!
Jul 31 09:46:01 sfd-db systemd[1]: Started MySQL Community Server.
## runtime parameters
5.6.51-log	sfd-db	3306	/workspace/mysql/data/	172.16.25.81	utf8	utf8_general_ci	1	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
## business databases
## business table count
0
## listening
LISTEN 0      150     172.16.25.81:3306      0.0.0.0:*    users:(("mysqld",pid=16869,fd=12))
## firewall
rule family="ipv4" source address="172.16.25.80/32" port port="3306" protocol="tcp" accept
## paths and permissions
644 root:root /etc/my.cnf
600 root:root /root/.my.cnf
750 mysql:mysql /workspace/mysql/data
750 mysql:mysql /workspace/mysql/log
755 mysql:mysql /usr/local/mysql-5.6.51
## configuration (non-secret)
[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8

[mysql]
default-character-set=utf8
no-auto-rehash

[mysqld]
user=mysql
port=3306
bind-address=172.16.25.81
basedir=/usr/local/mysql
datadir=/workspace/mysql/data
socket=/tmp/mysql.sock
pid-file=/workspace/mysql/mysql.pid

character-set-server=utf8
collation-server=utf8_general_ci
lower_case_table_names=1
skip-name-resolve
explicit_defaults_for_timestamp=1

max_connections=500
max_connect_errors=10000
open_files_limit=65535
table_open_cache=2048
thread_cache_size=64

innodb_file_per_table=1
innodb_buffer_pool_size=1G
innodb_log_file_size=256M
innodb_log_buffer_size=16M
innodb_flush_log_at_trx_commit=1

sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

log-error=/workspace/mysql/log/mysql-error.log
slow-query-log=1
slow-query-log-file=/workspace/mysql/log/mysql-slow.log
long-query-time=2

[mysqldump]
quick
max_allowed_packet=64M
## error log tail
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_METRICS'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_CMPMEM'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_CMP'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_LOCKS'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'INNODB_TRX'
2026-07-31 09:45:58 16305 [Note] Shutting down plugin 'InnoDB'
2026-07-31 09:45:58 16305 [Note] InnoDB: FTS optimize thread exiting.
2026-07-31 09:45:58 16305 [Note] InnoDB: Starting shutdown...
2026-07-31 09:46:00 16305 [Note] InnoDB: Shutdown completed; log sequence number 1626007
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'BLACKHOLE'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'ARCHIVE'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'MRG_MYISAM'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'MyISAM'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'MEMORY'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'CSV'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'sha256_password'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'mysql_old_password'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'mysql_native_password'
2026-07-31 09:46:00 16305 [Note] Shutting down plugin 'binlog'
2026-07-31 09:46:00 16305 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

2026-07-31 09:46:01 16869 [Note] Plugin 'FEDERATED' is disabled.
2026-07-31 09:46:01 16869 [Note] InnoDB: Using atomics to ref count buffer pool pages
2026-07-31 09:46:01 16869 [Note] InnoDB: The InnoDB memory heap is disabled
2026-07-31 09:46:01 16869 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2026-07-31 09:46:01 16869 [Note] InnoDB: Memory barrier is not used
2026-07-31 09:46:01 16869 [Note] InnoDB: Compressed tables use zlib 1.2.11
2026-07-31 09:46:01 16869 [Note] InnoDB: Using Linux native AIO
2026-07-31 09:46:01 16869 [Note] InnoDB: Using CPU crc32 instructions
2026-07-31 09:46:01 16869 [Note] InnoDB: Initializing buffer pool, size = 1.0G
2026-07-31 09:46:01 16869 [Note] InnoDB: Completed initialization of buffer pool
2026-07-31 09:46:01 16869 [Note] InnoDB: Highest supported file format is Barracuda.
2026-07-31 09:46:01 16869 [Note] InnoDB: 128 rollback segment(s) are active.
2026-07-31 09:46:01 16869 [Note] InnoDB: Waiting for purge to start
2026-07-31 09:46:01 16869 [Note] InnoDB: 5.6.51 started; log sequence number 1626007
2026-07-31 09:46:01 16869 [Note] RSA private key file not found: /workspace/mysql/data//private_key.pem. Some authentication plugins will not work.
2026-07-31 09:46:01 16869 [Note] RSA public key file not found: /workspace/mysql/data//public_key.pem. Some authentication plugins will not work.
2026-07-31 09:46:01 16869 [Note] Server hostname (bind-address): '172.16.25.81'; port: 3306
2026-07-31 09:46:01 16869 [Note]   - '172.16.25.81' resolves to '172.16.25.81';
2026-07-31 09:46:01 16869 [Note] Server socket created on IP: '172.16.25.81'.
2026-07-31 09:46:01 16869 [Warning] 'proxies_priv' entry '@ root@sfd-db' ignored in --skip-name-resolve mode.
2026-07-31 09:46:01 16869 [Note] Event Scheduler: Loaded 0 events
2026-07-31 09:46:01 16869 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.51-log'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)