it-source

manjaro에서 mariaDB를 시작할 수 없습니다.

criticalcode 2023. 1. 3. 21:46
반응형

manjaro에서 mariaDB를 시작할 수 없습니다.

phpmyadmin을 시작하려고 하는데 mariadb를 먼저 시작할 수 없습니다.다음은 제가 실행하려는 명령어입니다.
systemctl start mariadb

Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.

기타 명령어:
journalctl -xeu mariadb.service

Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [Note] InnoDB: 10.6.4 started; log sequence number 33110; transaction id 4
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [Note] InnoDB: Buffer pool(s) load completed at 210930  9:00:45
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [Note] Server socket created on IP: '0.0.0.0'.
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [Note] Server socket created on IP: '::'.
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
Sep 30 09:00:45 vincent mariadbd[5314]: 2021-09-30  9:00:45 0 [ERROR] Aborting
Sep 30 09:00:46 vincent mariadbd[5314]: Warning: Memory not freed: 280
Sep 30 09:00:46 vincent systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

pacman -Qs mariadb

local/mariadb 10.6.4-1
    Fast SQL database server, derived from MySQL
local/mariadb-clients 10.6.4-1
    MariaDB client tools
local/mariadb-libs 10.6.4-1
    MariaDB libraries

무엇이 문제인지 이해할 수 없는 것 같습니다.mysql.db가 존재하지 않기 때문입니까?그렇다면 어떻게 작성해야 합니까?

행운을 빌어요.

도커라이즈된 버전을 사용하여 도커 컴포지트 환경에서 링크하는 것을 제안해도 될까요?파일은 다음과 같습니다.

version: '3'
 
services:
  db:
    image: mariadb:10.6.4
    container_name: db
    environment:
      MARIADB_ROOT_PASSWORD: my_secret_password
      MARIADB_DATABASE: app_db
      MARIADB_USER: db_user
      MARIADB_PASSWORD: db_user_pass
    ports:
      - "6033:3306"
    volumes:
      - dbdata:/var/lib/mysql
  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    container_name: pma
    links:
      - db
    environment:
      PMA_HOST: db
      PMA_PORT: 3306
      PMA_ARBITRARY: 1
    restart: always
    ports:
      - 8081:80
volumes:
  dbdata:

mariadb-install-db --user mysql이 디렉토리에 인스톨 됩니다.왜 공백인지 불분명합니다.일반적으로 패키지 매니저pacman벌써 이렇게 했을 거야

언급URL : https://stackoverflow.com/questions/69387804/cant-start-mariadb-on-manjaro

반응형