无法在 laravel gitlab ci 中迁移数据库



我有一个带有gitlab ci 的laravel配置

一切都会好起来,但当它到达"迁移命令"时,它就失败了。

这是我的yaml:

image: php:latest
services:
- mysql:latest
variables:
MYSQL_ROOT_PASSWORD: root
MYSQL_USER: homestead
MYSQL_PASSWORD: secret
MYSQL_DATABASE: homestead
DB_HOST: mysql
stages:
- test
cache:
paths:
- vendor/
test:
stage: test
before_script:
- apt-get update -yqq
- apt-get install gnupg -yqq
- apt-get install git libcurl4-gnutls-dev libicu-dev libmcrypt-dev libvpx-dev libjpeg-dev libpng-dev libxpm-dev zlib1g-dev libfreetype6-dev libxml2-dev libexpat1-dev libbz2-dev libgmp3-dev libldap2-dev unixodbc-dev libpq-dev libsqlite3-dev libaspell-dev libsnmp-dev libpcre3-dev libtidy-dev -yqq libzip-dev
- docker-php-ext-install mbstring pdo_mysql curl json intl gd xml zip bz2 opcache
- pecl install xdebug
- docker-php-ext-enable xdebug
- curl -sS https://getcomposer.org/installer | php
- php composer.phar install
- cp .env.example .env
- php artisan key:generate
- php artisan config:cache
- php artisan migrate -v
script:
- php vendor/bin/phpunit --coverage-text --colors=never
only:
- master

这是我收到的错误:

IlluminateDatabaseQueryException  : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')

我强烈建议用mysql:5.7替换mysql:latest映像,因为MySQL 8默认使用另一种身份验证方法。

你的yaml文件应该像这样:

image: php:latest
services:
- mysql:5.7
# rest of your file

最新更新