MYSQL_USER=“root”, MYSQL_USER and MYSQL_PASSWORD are for configuring a regular user and cannot be used for the root user

[daguapp]

docker部署的时候遇到的问题，网上查了很久，docker-compose.yaml文件里的root用户配置删除就行了

[windy003]

删了还是不行,

anyan_mysql-1 | 2024-04-23T08:08:35.350382Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mtianyan_mysql-1 | 2024-04-23T08:08:35.440662Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mtianyan_mysql-1 | 2024-04-23T08:08:35.538876Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mtianyan_mysql-1 | 2024-04-23T08:08:35.555025Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the description of exact issue.
mtianyan_mysql-1 | 2024-04-23T08:08:35.555070Z 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
mtianyan_mysql-1 | mysqld: Cannot change permissions of the file 'private_key.pem.temp' (OS errno 1 - Operation not permitted)
mtianyan_mysql-1 | 2024-04-23T08:08:35.637484Z 0 [ERROR] [MY-010295] [Server] Could not set file permission for private_key.pem
mtianyan_mysql-1 | 2024-04-23T08:08:35.637521Z 0 [ERROR] [MY-010119] [Server] Aborting
mtianyan_mysql-1 | 2024-04-23T08:08:37.172969Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36) MySQL Community Server - GPL.