在Minikube中部署mysql:8失败，Pod反复重启报数据目录错误

问题场景 #

Ubuntu 20.04 LTS系统，使用Minikube 1.20（KVM2作为VM驱动）部署mysql:8镜像，挂载存储卷到容器内/var/lib/mysql路径，Pod出现持续重启现象，容器日志报错如下：

2023-01-17 07:15:17+00:00 [Note] [Entrypoint]: Initializing database files
2023-01-17T07:15:17.153897Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-01-17T07:15:17.154020Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-01-17T07:15:17.154036Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.31) initializing of server in progress as process 42
2023-01-17T07:15:17.155532Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2023-01-17T07:15:17.155536Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2023-01-17T07:15:17.155571Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-01-17T07:15:17.155647Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31)  MySQL Community Server - GPL.

问题原因 #

核心错误为--initialize specified but the data directory has files in it. Aborting.，说明挂载的存储卷目录中已存在旧的MySQL数据文件，触发镜像内置的初始化脚本执行中断，导致Pod启动失败并反复重启。

解决方案 #

方案1：清理存储卷内的旧数据（无需保留数据时使用） #

• 查看集群中关联的PersistentVolumeClaim（PVC）：

  kubectl get pvc
  

• 删除对应的PVC（关联的PersistentVolume会根据回收策略自动清理）：

  kubectl delete pvc <your-pvc-name>
  

• 若使用Minikube本地hostPath卷，可直接进入Minikube节点删除数据目录：

  minikube ssh
  sudo rm -rf /path/to/your/mysql/data/directory
  

• 重新部署MySQL服务，初始化脚本将正常执行。

方案2：跳过初始化流程（需保留旧数据时使用） #

MySQL镜像的entrypoint脚本会在首次启动时检测数据目录是否为空，若已有数据，可通过以下方式跳过初始化：

• 在Deployment的容器配置中添加环境变量（任选其一即可）：

  env:
    - name: MYSQL_ROOT_PASSWORD
      value: "your-existing-root-password"
    # 或允许空密码（仅测试环境使用）
    # - name: MYSQL_ALLOW_EMPTY_PASSWORD
    #   value: "yes"
  

• 或直接覆盖容器启动命令，跳过entrypoint的初始化逻辑：

  containers:
    - name: mysql
      image: mysql:8
      command: ["mysqld"]
      volumeMounts:
        - name: mysql-storage
          mountPath: /var/lib/mysql
  

内容的提问来源于stack exchange，提问作者Mohit Sharma