Skip to content
GitLab Next
  • Menu
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • gitlab-runner gitlab-runner
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Locked Files
  • Issues 2,478
    • Issues 2,478
    • List
    • Boards
    • Service Desk
    • Milestones
    • Iterations
    • Requirements
  • Merge requests 122
    • Merge requests 122
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
    • Test Cases
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Monitor
    • Monitor
    • Metrics
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Code review
    • Insights
    • Issue
    • Repository
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • GitLab.orgGitLab.org
  • gitlab-runnergitlab-runner
  • Issues
  • #1552
Closed
Open
Created Aug 02, 2016 by kujiy@kujiy

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?

root@be3e21d9cba7:/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"

root@be3e21d9cba7:/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                        
Assignee
Assign to
Time tracking