I didn't see any default table in mysql server when I run keycloak with mysql on docker

Docker Desktop
1

This is my docker compse file

services:

 keycloak:
  image: my-custom-keycloak:latest
  container_name: keycloak_server
  environment:
   KC_BOOTSTRAP_ADMIN_USERNAME: admin
   KC_BOOTSTRAP_ADMIN_PASSWORD: admin
   DB_VENDOR: mysql
   DB_URL: jdbc:mysql://mysql-db:3306/keycloak_db?useSSL=false&serverTimezone=UTC
   DB_USER: keycloak
   DB_PASSWORD: password    
  ports:
   - "8084:8080"
  command: start-dev
  depends_on:
   - mysql-db
  networks:
   - keycloak_mysql_network

 mysql-db:
  image: mysql:8.0
  container_name: mysql_server
  restart: always
  environment:
    MYSQL_ROOT_PASSWORD: password
    MYSQL_DATABASE: keycloak_db
    MYSQL_USER: keycloak
    MYSQL_PASSWORD: password
  ports:
   - "3307:3306"
  volumes:
   - ./my.cnf:/etc/mysql/my.cnf 
   - mysql_data:/var/lib/mysql
  networks:
   - keycloak_mysql_network

volumes:
 mysql_data:

networks:
  keycloak_mysql_network:
    driver: bridge
2

Can you rephrase the question?

Please format your code/config by using 3 backticks before and after or select the text and press </> icon.

3

yes, I have finished to format my code.

4

I still don’t understand the question. Please rephrase it, maybe add some more context. What do you want to achieve?

5

When i run above docker compose file, I can access keycloak server and also create realm but I didn’t see any default table on db. That is my docker compose file.

6

What do you mean by default table? What do you expect to be there exactly and why ? We can help with Docker, but I don1t see how it is related to Docker.

Do you expect KeyCloak automatically creating tables after starting? Do you have error messages?

7

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.