title: How to test laravel 5.6 with mysql 8 docker
body: <p>Due to new hashing algorithms in <strong>mysql 8</strong> I am unable to successfully run CI tests in <strong>gitlab</strong> against this mysql version.</p>
  
  <p>I believe this applies to other CI engines also.</p>
  
  <p>Let's assume my <code>.gitlab-ci.yml</code> is as as simple as that:</p>
  
  <pre><code>build:
    stage: build
    image: chilio/laravel-dusk-ci:stable
    services:
      - mysql:8.0
  
    script:
      - cp .env.example .env
      - composer install
      - php artisan migrate
  </code></pre>
  
  <p>And this is the error I get:</p>
  
  <pre><code>SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
  </code></pre>
  
  <p>I've found different posts, about reconfiguring mysql instance, but this image is official mysql docker, and I believe it should work the same way, across different versions ...</p>
  
  <p>Images from mysql:5.5 to 5.7 didn't introduce any problems, but with mysql:8.0 I get error as stated before...</p>
  
  <p>So far I have not found any solution to get around this. </p>
  
  <p>Any ideas?</p>