Version 1.0.0
Language EN

MySQL Example

Example Yaml configuration for a project with a MySQL service dependency. The MySQL service will be available at database:5432.

kind: pipeline
name: default

steps:
- name: test
  image: mysql
  commands:
  - sleep 15
  - mysql -u root -h database --execute="SELECT VERSION();"

services:
- name: database
  image: mysql
  environment:
    MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
    MYSQL_DATABASE: test

Database Options

If you need to start the mysql container with additional runtime options you can override the entrypoint and command arguments.

services:
- name: database
  image: mysql
  entrypoint: [ "mysqld" ]
  command: [ "--character-set-server=utf8mb4" ]

Database Settings

The official MySQL image provides environment variables used at startup to create the default username, password, database and more. Please see the official image documentation for more details.

services:
- name: database
  image: mysql
  environment:
    MYSQL_DATABASE: test
    MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'

Common Problems

Initialization

If you are unable to connect to the MySQL container please make sure you are giving MySQL adequate time to initialize and begin accepting connections.

kind: pipeline
name: default

steps:
- name: test
  image: mysql
  commands:
  - sleep 15
  - mysql -u root -h database

Incorrect Hostname

You cannot use 127.0.0.1 or localhost to connect with the Mysql container. If you are unable to connect to Mysql please verify you are using the correct hostname, corresponding with the name of the mysql service container.

Bad:

steps:
- name: test
  image: mysql
  commands:
  - sleep 15
  - mysql -u root -h localhost

Good:

steps:
- name: test
  image: mysql
  commands:
  - sleep 15
  - mysql -u root -h database

services:
- name: database
  image: mysql

On This Page:

Getting Help

Mailing List
Search for information in the mailing list archives, or post a question.
Chat Support
Real-time chat support from maintainers and community members.