Can't connect to MySQL service with .gitlab-ci.yml
This .gitlab-ci.yml mysql sample does not work for me.
ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (113)
Does anyone know any reason?
[email protected]:/my/my_tool# cat .gitlab-ci.yml
services:
- mysql
variables:
# Configure mysql service (https://hub.docker.com/_/mysql/)
MYSQL_DATABASE: hello_world_test
MYSQL_ROOT_PASSWORD: mysql
connect:
image: mysql
script:
- echo "SELECT 'OK';" | mysql --user=root --password="$MYSQL_ROOT_PASSWORD" --host=mysql "$MYSQL_DATABASE"
[email protected]:/my/my_tool# gitlab-runner exec docker connect
WARNING: You most probably have uncommitted changes.
WARNING: These changes will not be tested.
Running with gitlab-ci-multi-runner 1.4.1 (fae8f18)
Using Docker executor with image mysql ...
Pulling docker image mysql:latest ...
Starting service mysql:latest ...
Waiting for services to be up and running...
*** WARNING: Service runner--project-1-concurrent-0-mysql probably didn't start properly.
container already exists
*********
Pulling docker image mysql ...
Running on runner--project-1-concurrent-0 via be3e21d9cba7...
Cloning repository...
Cloning into '/builds/project-1'...
done.
Checking out b21a51b2 as master...
$ echo "SELECT 'OK';" | mysql --user=root --password="$MYSQL_ROOT_PASSWORD" --host=mysql "$MYSQL_DATABASE"
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (113)
ERROR: Build failed: exit code 1
FATAL: exit code 1