This action sets up a MySQL database for use in actions by:

• download a version of MySQL or MariaDB
• start mysqld

• GitHub-Hosted Runners have MySQL Server, but only Linux.
• GitHub Actions supports Docker services, and there is the official MySQL image. But it works on only Linux.
• Some utils for MySQL (such as MySQL::Partition, App::Prove::Plugin::MySQLPool, Test::mysqld) requires MySQL installed on the local host.

steps:
  - uses: actions/checkout@v4
  - uses: shogo82148/actions-setup-mysql@v1
    with:
      mysql-version: "8.0"
  - run: mysql -uroot -e 'SELECT version()'

The version of MySQL or MariaDB.

Available Versions are:

• MySQL
  • 8.4
  • 8.3
  • 8.2
  • 8.1
  • 8.0
  • 5.7
  • 5.6
• MariaDB
  • 11.5
  • 11.4
  • 11.3
  • 11.2
  • 11.1
  • 11.0
  • 10.11
  • 10.10
  • 10.9
  • 10.8
  • 10.7
  • 10.6
  • 10.5
  • 10.4
  • 10.3
  • 10.2

The distribution. The valid values are mysql or mariadb. The default value is mysql.

You can use mysql- and mariadb- prefixes in mysql-version instead of the distribution input. For example, the following two workflows install MariaDB 10.6.

- uses: shogo82148/actions-setup-mysql@v1
  with:
    distribution: "mariadb"
    mysql-version: "10.6"

- uses: shogo82148/actions-setup-mysql@v1
  with:
    mysql-version: "mariadb-10.6"

If it is true, the action starts the MySQL server. If it is false, the action doesn't start the MySQL sever. You need to execute the mysqld command yourself.

The default value is true.

my.cnf settings for mysqld. It uses the same syntax as my.cnf.

Example:

- uses: shogo82148/actions-setup-mysql@v1
  with:
    mysql-version: "8.0"
    my-cnf: |
      innodb_log_file_size=256MB
      innodb_buffer_pool_size=512MB
      max_allowed_packet=16MB
      max_connections=50
      local_infile=1

The password for the root user.

The name of the new user.

The password for the new user.

The directory under which the mysql database is being created.

It contains:

• etc/my.cnf
• tmp/mysqld.log
• tmp/mysqld.pid
• tmp/mysql.sock
• var: The default path of datadir
• var/ca.pem: The root certificate of the certification authority for SSL/TLS
• var/server-cert.pem: The server certificate for SSL/TLS
• var/server-key.pem: The server key for SSL/TLS

Here are some examples:

- id: setup-mysql
  uses: shogo82148/actions-setup-mysql@v1
  with:
    mysql-version: "8.0"

- name: connect via unix domain socket
  run: mysql -uroot \
    --protocol=SOCKET \
    --socket=${{ steps.setup-mysql.outputs.base-dir }}/tmp/mysql.sock
    -e 'SELECT version()'

- name: configure the root certificate for connecting via SSL/TLS.
  run: mysql -uroot \
    --ssl --ssl-mode=--ssl-mode=REQUIRED \
    --ssl-ca=${{ steps.setup-mysql.outputs.base-dir }}/var/ca.pem \
    -e 'SELECT version()'

The path to the directory in which the server-specific my.cnf file resides.