title: How to run a Prisma migration with Mysql on Docker with Github-actions
body: <p>My application uses Docker to run a MySQL DB, and Prisma to connect to it. I am writing a gh-action which tests the app after each push. I have followed this guide <a href="https://docs.github.com/en/actions/using-containerized-services/creating-postgresql-service-containers" rel="nofollow noreferrer">here</a> on how to run docker on gh-actions. I am also testing this action with <a href="https://github.com/nektos/act" rel="nofollow noreferrer">act</a>.</p>
  <p>My <strong>.github/workflows/main.yml</strong> looks like this:</p>
  <pre><code>name: NestJS CI/CD
  
  on:
    push:
      branches:
        - feature/gh-actions
  
  jobs:
    runner-job:
      runs-on: ubuntu-latest
  
      container: node:latest
  
      services:
        mysql:
          image: mysql
          ports:
            - '3306:3306'
          env:
            MYSQL_ROOT_PASSWORD: password
            MYSQL_DATABASE: db
          options: &gt;-
            --health-interval 10s
            --health-timeout 5s
            --health-retries 5
  
      steps:
        - name: Check out repository code
          uses: actions/checkout@v2
  
        - name: Install dependencies
          run: npm ci
  
        - name: Apply migrations
          run: npx prisma migrate dev
          env:
            DATABASE_URL: mysql://root:password@mysql:3306/db
  
        - name: Apply seed
          run: npx prisma db seed
  
        - name: Test the project
          run: npm run test
  </code></pre>
  <p>but I keep getting:</p>
  <pre><code>| Error: P1001: Can't reach database server at `mysql`:`3306`
  </code></pre>
  <p>Am I missing something?</p>