Why does my Docker MySQL lose privileges for some users?

brad.bulger

8/29/24, 6:38 PM

I am using the mysql 8 image in a docker compose file. Periodically I discover that the mysql user I set up for a database no longer has privileges on that database. The user still exists and has GRANT USAGE on *.* but all the database specific privileges are gone. I use this same user on multiple databases in this container. Is there something about my configuration that's causing mysql to lose that information? Or is it default and I need to do something to prevent it?

The relevant part of my docker-compose.yml file

  aspodb:
    container_name: aspodb
    image: mysql:8
    ports:
      - 3306:3306
    environment:
      MYSQL_ROOT_PASSWORD: root
    command: mysqld --max_allowed_packet=256M
    networks:
      - asponet
    volumes:
      - aspodata:/var/lib/mysql
      - aspodatatmp:/var/tmp
      - ./setup/mysql:/docker-entrypoint-initdb.d
      - ./setup/mysqlcnf/aspodb.cnf:/etc/mysql/conf.d/aspodb.cnf

0 + 0

mysql

docker

docker-compose

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Why does my Docker MySQL lose privileges for some users?

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.