Update laravel.yml with mysqk #9

	name: Laravel test via MySQL

	on:
	push:
	branches: [ "main" ]
	pull_request:
	branches: [ "main" ]

	jobs:
	laravel-tests:

	runs-on: ubuntu-latest

	services:
	mysql:
	image: mysql:5.7
	env:
	MYSQL_DATABASE: test_db
	MYSQL_USER: user
	MYSQL_PASSWORD: secret
	MYSQL_ROOT_PASSWORD: secretroot
	ports:
	- 3306
	options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

	steps:
	- uses: actions/checkout@v2

	- name: Verify MySQL connection
	run: \|
	mysql --version
	sudo apt-get install -y mysql-client
	mysql --host 127.0.0.1 --port ${{ job.services.mysql.ports['3306'] }} -uuser -psecret -e "SHOW DATABASES"

	- name: Copy .env
	run: php -r "file_exists('.env') \|\| copy('.env.example', '.env');"

	- name: Install Dependencies
	run: composer install -q --no-ansi --no-interaction --no-scripts --no-suggest --no-progress --prefer-dist

	- name: Generate key
	run: php artisan key:generate

	- name: Directory Permissions
	run: chmod -R 777 storage bootstrap/cache

	- name: Execute tests (Unit and Feature tests) via PHPUnit
	env:
	MYSQL_DATABASE: test_db
	DB_USERNAME: user
	DB_PASSWORD: secret
	DB_PORT: ${{ job.services.mysql.ports[3306] }}
	run: vendor/bin/phpunit

Provide feedback