SpecialistOff.NET / Вопросы / Статьи / Фрагменты кода / Резюме / Метки / Помощь / Файлы

Список вопросов Печать

Ошибка с правами при переходе с mysql:8.0.31 на percona/percona-server:8.0


Метки: mysql docker docker compose docker-compose.yml 

Было

services:
  db:
  image: mysql:8.0.31
  # env_file:
    #  - ./settings/.env.db
  volumes:
      - ./data/db:/var/lib/mysql

Стало

services:
  db:
  image: percona/percona-server:8.0
  # env_file:
    #  - ./settings/.env.db
  volumes:
      - ./data/db:/var/lib/mysql

Ошибка

db-1  | 2025-03-05T08:34:41.849077Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
db-1  | 2025-03-05T08:34:41.849101Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
db-1  | 2025-03-05T08:34:41.849134Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-32) starting as process 1
db-1  | 2025-03-05T08:34:41.851472Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
db-1  | mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
db-1  | 2025-03-05T08:34:41.851874Z 0 [ERROR] [MY-010119] [Server] Aborting
db-1  | 2025-03-05T08:34:41.851955Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-32)  Percona Server (GPL), Release 32, Revision b8e378ec.

Ответы

Возможно будут интересны и другие вопросы