● 2023-01-03T03:49:56.400532Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2023-01-03T03:49:56.400554Z 0 [Note] mysqld (mysqld 5.7.27-log) starting as process 878484 …
2023-01-03T03:49:56.403473Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-01-03T03:49:56.403496Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-01-03T03:49:56.403501Z 0 [Note] InnoDB: Uses event mutexes
2023-01-03T03:49:56.403510Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-01-03T03:49:56.403547Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-03T03:49:56.403551Z 0 [Note] InnoDB: Using Linux native AIO
2023-01-03T03:49:56.403777Z 0 [Note] InnoDB: Number of pools: 1
2023-01-03T03:49:56.403827Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2023-01-03T03:49:56.404504Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-01-03T03:49:56.410780Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-03T03:49:56.411459Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-01-03T03:49:56.422478Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-01-03T03:49:56.422784Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3151127
2023-01-03T03:49:56.422801Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3151136
2023-01-03T03:49:56.422805Z 0 [Note] InnoDB: Database was not shutdown normally!
2023-01-03T03:49:56.422817Z 0 [Note] InnoDB: Starting crash recovery.
2023-01-03T03:49:56.539453Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2023-01-03T03:49:56.539482Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-03T03:49:56.539525Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2023-01-03T03:49:56.560748Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2023-01-03T03:49:56.561301Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-01-03T03:49:56.561319Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-01-03T03:49:56.561550Z 0 [Note] InnoDB: Waiting for purge to start
2023-01-03T03:49:56.611677Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 3151136
2023-01-03T03:49:56.611801Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
2023-01-03T03:49:56.611945Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2023-01-03T03:49:56.612894Z 0 [Note] Recovering after a crash using /data/mysql/data/mysql-bin
2023-01-03T03:49:56.612913Z 0 [Note] Starting crash recovery…
2023-01-03T03:49:56.612943Z 0 [Note] Crash recovery finished.
2023-01-03T03:49:56.613650Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230103 11:49:56
2023-01-03T03:49:56.636916Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2023-01-03T03:49:56.636929Z 0 [Note] Server hostname (bind-address): ‘*’; port: 3306
2023-01-03T03:49:56.636959Z 0 [Note] IPv6 is available.
2023-01-03T03:49:56.636966Z 0 [Note] - ‘::’ resolves to ‘::’;
2023-01-03T03:49:56.636975Z 0 [Note] Server socket created on IP: ‘::’.
2023-01-03T03:49:56.655916Z 0 [Warning] Detected misconfiguration: replication channel ‘’ was configured with AUTO_POSITION = 1, but the server was started with --gtid-mode=off. Either reconfigure replication using CHANGE MASTER TO MASTER_AUTO_POSITION = 0 FOR CHANNEL ‘’, or change GTID_MODE to some value other than OFF, before starting the slave receiver thread.
2023-01-03T03:49:56.655983Z 0 [ERROR] mysqld: The replication receiver thread for channel ‘’ cannot start in AUTO_POSITION mode: this server uses @@GLOBAL.GTID_MODE = OFF.
2023-01-03T03:49:56.656015Z 0 [ERROR] Failed to start slave threads for channel ‘’
2023-01-03T03:49:56.659842Z 0 [Note] Event Scheduler: Loaded 0 events
2023-01-03T03:49:56.660113Z 0 [Note] mysqld: ready for connections.
Version: ‘5.7.27-log’ socket: ‘/data/mysql/run/mysqld.sock’ port: 3306 Source distribution
这没有说处理mysql问题的啊。
走错场地了吧