How to use MySQL in Gitlab CI

Nik · December 16, 2015, 10:15am

I am trying to run WordPress PHP unit tests on Gitlab CI.

I searched too much but I am not able to set up MySQL and create and use a database for testing. Can anybody show an example for this?

Example of .gitlab-ci.yml and commands to create database would be very helpful.

This is the test install script I will be using -

github.com

Nikschavan/wp-freshdesk/blob/master/bin/install-wp-tests.sh

#!/usr/bin/env bash

if [ $# -lt 3 ]; then
	echo "usage: $0 <db-name> <db-user> <db-pass> [db-host] [wp-version]"
	exit 1
fi

DB_NAME=$1
DB_USER=$2
DB_PASS=$3
DB_HOST=${4-localhost}
WP_VERSION=${5-latest}

WP_TESTS_DIR=${WP_TESTS_DIR-/tmp/wordpress-tests-lib}
WP_CORE_DIR=${WP_CORE_DIR-/tmp/wordpress/}

download() {
    if [ `which curl` ]; then
        curl -s "$1" > "$2";
    elif [ `which wget` ]; then

This file has been truncated. show original

axil · December 18, 2015, 6:39pm

Hi @Nik have you seen http://doc.gitlab.com/ce/ci/languages/php.html ? I’d be glad to get some feedback.

Nik · December 29, 2015, 10:04am

Hey @axil, Thank you for the link, this helped me a lot.

I got CI up and running for PHP tests, but for WordPress tests I am still facing problems with MySql.

Is there a way I can test if MySql is working inside the CI enviornment? when I check mysql --version it fails with mysql: command not found

axil · January 3, 2016, 11:18am

Can you post your current .gitlab-ci.yml?

mooska · April 18, 2016, 2:09pm

Just as a note, because I was looking for an answer for a few hours. Usually, your image wont have mysql-client, so you cant connect to the service out of the box. It would be nice to have this kind of information anywhere in documentation, because its not really that obvious

Just install it:
apt-get --assume-yes install mysql-client

and then you can connect, remember the host is “mysql” not localhost
mysql -h mysql -u root -p somefancypassword

danger89 · April 19, 2016, 4:44pm

You could use the MySQL image?
https://hub.docker.com/_/mysql/

During the runner register you can say which image you want to use. Or you can define the image within the .gitlab-ci.yml file at the top of the file. Like so:

image: mysql:5.5

or atleast take a look at this docker file to create your own Docker image:

github.com

docker-library/mysql/blob/d7e71447ff3ad3c579ac3cca8c0dc090d11d4baf/5.5/Dockerfile

FROM debian:jessie

# add our user and group first to make sure their IDs get assigned consistently, regardless of whatever dependencies get added
RUN groupadd -r mysql && useradd -r -g mysql mysql

RUN mkdir /docker-entrypoint-initdb.d

# FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db:
# File::Basename
# File::Copy
# Sys::Hostname
# Data::Dumper
RUN apt-get update && apt-get install -y perl --no-install-recommends && rm -rf /var/lib/apt/lists/*

# mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
RUN apt-get update && apt-get install -y libaio1 pwgen && rm -rf /var/lib/apt/lists/*

ENV MYSQL_MAJOR 5.5
ENV MYSQL_VERSION 5.5.49

This file has been truncated. show original

Conradjones · May 1, 2016, 8:43am

I install it via the gitlab-ci.yml

Topic		Replies	Views
[solved]Gitlab CI tests for WordPress GitLab CI/CD	6	5883	June 22, 2016
Gitlab ci configuration with mysql How to Use GitLab	2	2061	September 28, 2018
[Resolved]Create database GitLab CI/CD	2	2867	March 31, 2017
Running MySQL inside GitLab Runner GitLab CI/CD ci , runner	3	6959	May 10, 2021
Looking for resources for setting up CI to test PHP website How to Use GitLab	1	801	September 23, 2016

How to use MySQL in Gitlab CI

Related topics