title: Docker-compose mysql environment difference between PASSWORD and ROOT_PASSWORD
body: <p>This is from my docker compose: </p>
  
  <pre><code> db:
          image: mysql
          ports: 
              - "3306:3306"
          environment:
              MYSQL_DATABASE: myDb
              MYSQL_USER: user
              MYSQL_PASSWORD: test
              MYSQL_ROOT_PASSWORD: test 
          volumes:
              - ./dump:/docker-entrypoint-initdb.d
              - persistent:/var/lib/mysql
  </code></pre>
  
  <p>When I change my user and both passwords to 'root', my database gets created but it's empty. When I leave the credentials as above, my .sql script inside my /dump dir populates the database as it is supposed to. How do the credentials change affect data injection and how can I fix this?</p>