Multiple Mysql Instances in bitbucket pipelines

[jordanvector]

I am wondering if it is possible to spin up two different databases on the same mysql instance in bitbucket pipelines during testing

[Nathan Rzepecki]

Did you work this out?

[Alex Bergin]

You could call the mysql client with the root password to create another database, like so:

image: php:7.2-fpm-alpine
pipelines: 
  default: 
    - step: 
        script: 
          - ... 
          - RUN apk add mysql-client
          - mysql -u root -pyo -h 127.0.0.1 -e "CREATE DATABASE pipelines_secondary"
          - ...

        services: 
          - mysql

definitions: 
  services: 
    mysql: 
      image: mysql:5.7 
      environment: 
        MYSQL_DATABASE: 'pipelines'
        MYSQL_ROOT_PASSWORD: 'yo' 
        MYSQL_USER: 'test_user'
        MYSQL_PASSWORD: 'test_user_password'