title: Creating test database with Laravel sail
body: <p>I'm trying to create a test database for my using Laravel and Sail.  Following <a href="https://stackoverflow.com/questions/65645506/using-laravel-sail-with-a-separate-testing-database">this post</a>, I updated my docker-compose file with:</p>
  <pre><code>    mysql:
          image: 'mysql:8.0'
          ports:
              - '${FORWARD_DB_PORT:-3306}:3306'
          environment:
              MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
              MYSQL_DATABASE: '${DB_DATABASE}'
              MYSQL_USER: '${DB_USERNAME}'
              MYSQL_PASSWORD: '${DB_PASSWORD}'
              MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
          volumes:
              - 'sailmysql:/var/lib/mysql'
          networks:
              - sail
          healthcheck:
            test: [&quot;CMD&quot;, &quot;mysqladmin&quot;, &quot;ping&quot;]
      mysql_test:
        image: &quot;mysql:8.0&quot;
        environment:
          MYSQL_ROOT_PASSWORD: &quot;${TEST_DB_PASSWORD}&quot;
          MYSQL_DATABASE: &quot;${TEST_DB_DATABASE}&quot;
          MYSQL_USER: &quot;${TEST_DB_USERNAME}&quot;
          MYSQL_PASSWORD: &quot;${TEST_DB_PASSWORD}&quot;
          MYSQL_ALLOW_EMPTY_PASSWORD: &quot;yes&quot;
        networks:
          - sail
  </code></pre>
  <p>In my .env file I have:</p>
  <pre><code>DB_CONNECTION=mysql
  DB_HOST=mysql
  DB_PORT=3306
  DB_DATABASE=real_database
  DB_USERNAME=root
  DB_PASSWORD=root
  
  TEST_DB_CONNECTION=mysql
  TEST_DB_HOST=mysql_test
  TEST_DB_PORT=3306
  TEST_DB_DATABASE=test_database
  TEST_DB_USERNAME=root
  TEST_DB_PASSWORD=root
  </code></pre>
  <p>However, when I run sail up, I get:</p>
  <pre><code>mysql_test_1    | 2021-03-13 17:18:10+00:00 [Note] [Entrypoint]: Creating database test_database
  mysql_test_1    | 2021-03-13 17:18:10+00:00 [Note] [Entrypoint]: Creating user root
  mysql_test_1    | ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'%'
  </code></pre>
  <p>Any thoughts on why the build is failing?</p>