Mysql healthy check problem

[Shengshenlan]

📋 CheckList

• I have searched existing issues to avoid duplicates
• I am using a recently maintained version of Coze Loop
• I have provided all required information
• I understand this is a bug report and not a feature request
• I have submitted this report in English (otherwise it will not be processed)

🐛 Bug Description

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

🔄 Steps to Reproduce

.cnf 文件
USER=root
PASSWORD=cozeloop-mysql
DATABASE=cozeloop-mysql
client_template.cnf
[client]
user=${USER}
password=${PASSWORD}
host=localhost

✅ Expected Behavior

123

❌ Actual Behavior

123

🚨 Severity

None

🔧 Component

None

💻 Environment

No response

🔧 Go Environment

No response

📋 Logs

cozeloop-mysql  | [client]
cozeloop-mysql  | user=root
cozeloop-mysql  | password=cozeloop-mysql
cozeloop-mysql  | host=localhost
cozeloop-mysql  | =========================================================================
cozeloop-mysql  | ============================== Starting... ==============================
cozeloop-mysql  | =========================================================================
cozeloop-mysql  | + docker-entrypoint.sh mysqld
cozeloop-mysql  | 2025-07-29 02:09:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.4.0-1.el9 started.
cozeloop-mysql  | 2025-07-29 02:09:14+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cozeloop-mysql  | 2025-07-29 02:09:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.4.0-1.el9 started.
cozeloop-mysql  | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cozeloop-mysql  | 2025-07-29T02:09:14.675006Z 0 [System] [MY-015015] [Server] MySQL Server - start.
cozeloop-mysql  | 2025-07-29T02:09:14.890230Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.4.0) starting as process 71
cozeloop-mysql  | 2025-07-29T02:09:14.890250Z 0 [System] [MY-015590] [Server] MySQL Server has access to 16 logical CPUs.
cozeloop-mysql  | 2025-07-29T02:09:14.890265Z 0 [System] [MY-015590] [Server] MySQL Server has access to 33649065984 bytes of physical memory.
cozeloop-mysql  | 2025-07-29T02:09:14.896060Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cozeloop-mysql  | 2025-07-29T02:09:17.139853Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
cozeloop-mysql  | 2025-07-29T02:09:19.447613Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
cozeloop-mysql  | 2025-07-29T02:09:19.454965Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
cozeloop-mysql  | 2025-07-29T02:09:19.983816Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
cozeloop-mysql  | 2025-07-29T02:09:19.983852Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
cozeloop-mysql  | 2025-07-29T02:09:20.214790Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
cozeloop-mysql  | 2025-07-29T02:09:20.543593Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
cozeloop-mysql  | 2025-07-29T02:09:20.543627Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.4.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
cozeloop-mysql  | + init #1: mysql --defaults-extra-file=<(client_conf) -D cozeloop-mysql < /cozeloop/conf/mysql/init-sql/api_key.sql
cozeloop-mysql  | ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

📝 Additional Context

No response

[Pancat009]

same issue

[Shengshenlan]

same issue
are you slove this issue?

[biwang75678]

Did you modify the .cnf file? Please keep it as is

[client]
user=${USER}
password=${PASSWORD}
host=127.0.0.1

[biwang75678]

However, we'll update to .env configuration method in our next release, which is much better

[Shengshenlan]

Did you modify the .cnf file? Please keep it as is

[client] user=${USER} password=${PASSWORD} host=127.0.0.1

If I not change it, I will encounter this problem

cozeloop-mysql  | 2025-07-29T03:11:08.321245Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.

cozeloop-mysql  | 2025-07-29T03:11:10.503839Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.4.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
cozeloop-mysql  | 2025-07-29T03:11:10.503902Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
cozeloop-mysql  | + Ensuring database 'cozeloop-mysql' exists
cozeloop-mysql  | ERROR 1130 (HY000): Host '127.0.0.1' is not allowed to connect to this MySQL server

[GUNJOTH]

怎么解决

[Shengshenlan]

怎么解决

不要用它的 容器里带的 mysql 直接 自己外面 安装一个把

[Shengshenlan]

cozeloop-app | 2025/07/29 07:28:24 /cozeloop/backend/modules/evaluation/infra/repo/experiment/mysql/expt_stats.go:87 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'created_at' at row 1
cozeloop-app | [1.229ms] [rows:0] UPDATE expt_stats SET space_id=7532398619123515393,expt_id=7532401064469856257,pending_cnt=2,success_cnt=0,fail_cnt=0,credit_cost=0,input_token_cost=0,output_token_cost=0,created_at='0000-00-00 00:00:00',updated_at='2025-07-29 07:28:24.497',deleted_at=NULL,processing_cnt=0,terminated_cnt=0 WHERE expt_stats.deleted_at IS NULL AND id = 7532401064469872641
cozeloop-app | ERROR 2025-07-29 07:28:24,498 expt_run_scheduler_event_impl.go:198 [ExptEval] HandleEventErr found error: update ExptStats fail, stats: {"id":7532401064469872641,"space_id":7532398619123515393,"expt_id":7532401064469856257,"pending_cnt":2,"success_cnt":0,"fail_cnt":0,"credit_cost":0,"input_token_cost":0,"output_token_cost":0,"created_at":"0001-01-01T00:00:00Z","updated_at":"2025-07-29T07:28:24.497Z","deleted_at":null,"processing_cnt":0,"terminated_cnt":0}
cozeloop-app | cause=Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'created_at' at row 1

bug_report

[yijiaquan]

解决方案：host修改为localhost，，若启动过必须将volumes coze-loop_mysql_data删除后再重启

[t880216t]

解决方案：host修改为localhost，，若启动过必须将volumes coze-loop_mysql_data删除后再重启

改了host，依旧报错。
部署系统：wsl中的ubutnu

[Pancat009]

兄弟们，终于成功了，集结了Copilot，Cursor和Trae之力，

1. Add 0-init-database.sql to /conf/default/mysql

CREATE DATABASE IF NOT EXISTS `cozeloop-mysql` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

no worries, all the .sql files will be executed automatically

2. below is my /conf/default/mysql/entrypoint.sh, you guy can refer, change it to ensure executing init-database.sql for the first time

#!/bin/bash

exec 2>&1
set -e

# volumes:
#   - ./conf/default/mysql:/cozeloop/conf/mysql
#   - ./conf/default/tools:/cozeloop/conf/tools
CONF_PATH="/cozeloop/conf"
MYSQL_CONF_PATH="$CONF_PATH/mysql"
TOOLS_CONF_PATH="$CONF_PATH/tools"

. "$TOOLS_CONF_PATH/print_banner.sh"
. "$MYSQL_CONF_PATH/.cnf"

client_conf() {
  sh "$TOOLS_CONF_PATH/var_subst.sh" "$MYSQL_CONF_PATH/client_template.cnf" "$MYSQL_CONF_PATH/.cnf"
}

export MYSQL_ROOT_PASSWORD=${PASSWORD}
export MYSQL_DATABASE=${DATABASE}
export MYSQL_USER=cozeloop
export MYSQL_PASSWORD=${PASSWORD}

print_banner "Starting..."
print_banner_delay "Successfully Started!" 12

echo "+ docker-entrypoint.sh mysqld"
docker-entrypoint.sh mysqld &

# 等待MySQL启动
echo "Waiting for MySQL to start..."
until mysqladmin ping -h localhost -u root -p${PASSWORD} --silent; do
  echo "MySQL is not ready yet..."
  sleep 5
done

echo "MySQL is ready!"

# 等待一段时间确保MySQL完全启动
sleep 10

# 执行初始化脚本
i=1
for f in "$MYSQL_CONF_PATH/init-sql/"*.sql; do
  if [ -f "$f" ]; then
    if [ $i -eq 1 ]; then
      echo "+ init #$i: mysql -u root -p${PASSWORD} < $f"
      mysql -u root -p${PASSWORD} < "$f"
    else
      echo "+ init #$i: mysql -u root -p${PASSWORD} -D $DATABASE < $f"
      mysql -u root -p${PASSWORD} -D "$DATABASE" < "$f"
    fi
    i=$((i + 1))
  fi
done

wait

3. because I'm using Windows - Docker Desktop
   change the .cnf format from CRLF to LF (bottom right corner of VS Code) if necessary

4. I've added the host and port in conf/default/mysql/.cnf

USER=root
PASSWORD=cozeloop-mysql
DATABASE=cozeloop-mysql
HOST=localhost
PORT=3306

TBH, feel pretty frustrated during testing.
recommend you guys to use Linux to run the docker

if the above steps still doesn't work, try your own AI IDE!!! I'm not the expert!
maybe I'm missing some files that has been changed, all done by AI.
MANY THANKS TO AI.

p.s. 建议作者可以先改改好测试一下再放出来，希望后面有新版本的话可以不用那么折腾，折磨了我2天...

[yijiaquan]

解决方案：host修改为localhost，，若启动过必须将volumes coze-loop_mysql_data删除后再重启

改了host，依旧报错。 部署系统：wsl中的ubutnu

你好，请展示下容器错误日志，wsl+docker desktop或wsl+Ubuntu+docker都是正常的，检查下是不是第一次启动的volume未清除，可以只启动mysql服务(docker-compose up -d mysql)更好排查

[lsy357]

We provided a Docker image and deployment tools based on the image in v1.1.0. You can refer to the documentation and try it out. Please report any issues in the deployment.