Enabling GoCD to use MySQL

    In order to use MySQL database with GoCD, an external MySQL database server is needed to host the GoCD Server’s database. Refer documentation to install the latest MySQL Database Server based on your environment. GoCD supports MySQL version 8.0.

    Note: GoCD needs support for case-insensitive identifiers and on Unix systems at least this needs to be done before MySQL is installed! These pages from the MySQL documentation might be useful:

    Once the MySQL Server is started, an empty database can be created from the command-line using the mysql or utilities, which MySQL ships with. Refer create database documentation to setup database.

    A properties file with the name needs to be created in the GoCD’s configuration directory (config/). The location of GoCD’s configuration directory varies per operating system. Refer to know the location of GoCD Server config directory.

    This file should contain information about the database server, so that the GoCD Server can connect to it.

    See GoCD Database Configuration Properties to know the full list of configuration properties that can be specified under .

    See to start your GoCD Server.

    MySQL: Identifier case senitivity

    You might see a message such as this in the GoCD server logs, if you are using MySQL:

    If you see this, the most probable cause is that your MySQL instance has turned on. GoCD needs case-insensitive identifiers and you will need to change your MySQL instance to enable that. Please note that, according to the documentation, it is not possible to change the lower_case_table_names variable once the MySQL instance is initialized. You might need to recreate the instance.