No able to run parallel testing: sail test --parallel

These are the steps, from scratch:

• Docker 4.0.1 in Windows 10 is running
• Ubuntu 20.04 is in WSL2 mode
• within ~ run curl -s https://laravel.build/example-app | bash
• cd example-app
• sail up -d
• sail test --parallel is successful (after Running tests in parallel requires "brianium/paratest". Do you wish to install it as a dev dependency? - yes):

Time: 00:00.418, Memory: 20.00 MB
OK (2 tests, 2 assertions)

But then:

• nano tests\Features\ExampleTest.php to import use RefreshDatabase;

namespace Tests\Feature;

use Illuminate\Foundation\Testing\RefreshDatabase;
use Tests\TestCase;

class ExampleTest extends TestCase
{
    use RefreshDatabase;

    /**
     * A basic test example.
     *
     * @return void
     */
    public function test_example()
    {
        $response = $this->get('/');

        $response->assertStatus(200);
    }
}

There was 1 error:

1. Tests\Feature\ExampleTest::test_example Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'sail'@'%' to database 'example_app_test_2' (SQL: drop database if exists example_app_test_2)

What am I missing?

Maybe I am doing something wrong, but to boil it down: mySQL user that is created as container goes up is only granted access to the DB that is created (well, duh).

So what I ended up doing is add an extra step for testing mysql container, to provide access to all DBs, automating solution @frankielee suggested with

1. a file in docker/mysql.testing/init/01-database.sql

GRANT ALL PRIVILEGES ON *.* TO 'sail'@'%';

(assumes your DB_USER is .env is sail)

and 2. mapping it to a volume in mysql.testing container in docker-compose.yml:

    mysql.testing:
        tmpfs: '/var/lib/mysql'
        image: 'mysql:5.7'
        ports:
            - '${FORWARD_DB_PORT:-53306}: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:
            - "./docker/mysql.testing/init:/docker-entrypoint-initdb.d"
        networks:
            - sail
        healthcheck:
          test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
          retries: 3
          timeout: 5s

Notice that the the container side of DB port is mapped to 53306 - to avoid conflict with regular mySQL db.

Since no one else seems to be having the problem, I doubt anyone will find this post useful, but just in case, a note of caution: remember that volumes need to be recreated, so sail down -v is needed

Ta-da for now