MariaDB/MySQL docker image does not populate the db in the init script

Question

services:
  mariadb:
    image: mariadb:10.5.8-focal
    env_file:
      - .env
    volumes:
      - .data/mariadb:/var/lib/mysql
      - .docker/mysql/init/:/docker-entrypoint-initdb.d/
    ports:
      - "3308:3306"

having an init script.sql

CREATE DATABASE 'biostar';
grant all privileges on *.* to 'root'@'172.18.0.3' identified by 'biostar';
grant all privileges on *.* to 'biostar'@'172.18.0.3' identified by 'biostar';

expected: a db with name biostar

actual: no extra db, just the default ones

where is script.sql located? Is it in ${PWD}/.docker/mysql/init? — richyen
– richyen, Commented Jan 6, 2021 at 7:39

richyen · Accepted Answer · 2021-01-06 07:42:01Z

1

There are a few things that might be causing your issue.

First, CREATE DATABASE 'biostar'; is incorrect syntax -- you need to use backticks and not single-quotes

Second, script.sql needs to be in the .docker/mysql/init folder (and the .docker folder needs to be in the same folder as your docker-compose.yaml, or you should specify a full path that begins with /)

answered Jan 6, 2021 at 7:42

richyen

10.3k4 gold badges18 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

omars Over a year ago

quotes worked, but the problem was a prefix with ./ was missing

Collectives™ on Stack Overflow

MariaDB/MySQL docker image does not populate the db in the init script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related