mysql无法正常启动

[zj198547]

Describe the bug

按照安装 Coze Studio 步骤执行，但是无法正常启动mysql;

To Reproduce

Steps to reproduce the behavior:

启动命令 docker compose --profile "*" up -d，无法正常启动coze-mysql

Screenshots

Version:

[zj198547]

2025-09-09 02:55:08+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.5-1.el9 started.

2025-09-09 02:55:11+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2025-09-09 02:55:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.5-1.el9 started.

ln: failed to create symbolic link '/var/lib/mysql/mysql.sock': Operation not permitted

2025-09-09T02:55:11.652400Z 0 [System] [MY-015015] [Server] MySQL Server - start.

2025-09-09T02:55:11.988181Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.5) starting as process 1

2025-09-09T02:55:12.019827Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive

2025-09-09T02:55:12.070505Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/lib/mysql/auto.cnf' is ignored.

2025-09-09T02:55:12.083167Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/lib/mysql/auto.cnf' has been removed.

2025-09-09T02:55:12.100098Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 675f6af7-8d28-11f0-8590-ae680f990baf.

2025-09-09T02:55:12.265180Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2025-09-09T02:55:18.185226Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

mysqld: Table 'mysql.plugin' doesn't exist

2025-09-09T02:55:18.858369Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.

2025-09-09T02:55:18.859745Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables

2025-09-09T02:55:18.859834Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables

2025-09-09T02:55:18.859911Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables

2025-09-09T02:55:18.860137Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables

2025-09-09T02:55:18.860203Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables

2025-09-09T02:55:18.860286Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables

2025-09-09T02:55:18.860388Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables

2025-09-09T02:55:19.176402Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2025-09-09T02:55:19.636226Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2025-09-09T02:55:19.657153Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the description of exact issue.

2025-09-09T02:55:19.657198Z 0 [Warning] [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

mysqld: Cannot change permissions of the file 'private_key.pem.temp' (OS errno 1 - Operation not permitted)

2025-09-09T02:55:19.699078Z 0 [ERROR] [MY-010295] [Server] Could not set file permission for private_key.pem

2025-09-09T02:55:19.699681Z 0 [ERROR] [MY-010119] [Server] Aborting

2025-09-09T02:55:21.184523Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.5) MySQL Community Server - GPL.

2025-09-09T02:55:21.184544Z 0 [System] [MY-015016] [Server] MySQL Server - end.

[zj198547]

#91
已经解决了