MySQL GitHub Action 
This GitHub Action sets up a MySQL database in Docker.
It supports various MySQL options to accurately configure and execute MySQL. So it may not be your best choice when you just want to run a simple MySQL, see The Default MySQL.
It is based on the Docker container and is limited by Github Actions, which contains only Linux now. Therefore it does not work in Mac OS and Windows environment.
Usage
steps:
- uses: mirromutth/[email protected]
with:
host port: 3800 # Optional, default value is 3306. The port of host
container port: 3307 # Optional, default value is 3306. The port of container
character set server: 'utf8' # Optional, default value is 'utf8mb4'. The '--character-set-server' option for mysqld
collation server: 'utf8_general_ci' # Optional, default value is 'utf8mb4_general_ci'. The '--collation-server' option for mysqld
mysql version: '8.0' # Optional, default value is "latest". The version of the MySQL
mysql database: 'some_test' # Optional, default value is "test". The specified database which will be create
mysql root password: ${{ secrets.RootPassword }} # Required if "mysql user" is empty, default is empty. The root superuser password
mysql user: 'developer' # Required if "mysql root password" is empty, default is empty. The superuser for the specified database. Can use secrets, too
mysql password: ${{ secrets.DatabasePassword }} # Required if "mysql user" exists. The password for the "mysql user"If want bind MySQL host port to 3306, please see The Default MySQL.
See Docker Hub for available MySQL versions.
See Creating and using secrets (encrypted variables) for hiding database password.
The Default MySQL
MySQL may be installed and started by Github Actions (aka. the Default MySQL), that version is 5.7 generally, root superuser password is "root" and port is 3306. See Software in virtual environments for GitHub Actions.
So before set-up a MySQL which host port is 3306 in Docker, please make sure the Default MySQL has been shutted-down. Otherwise, action will fail and print an error log that looks like: Error starting userland proxy: listen tcp 0.0.0.0:3306: bind: address already in use. (See #2)
Sure, if you do not care about MySQL options, such as version, bound port, character set, character collation, root password, etc., you can use the Default MySQL instead of this Action.
Shutdown the Default MySQL
jobs:
build:
runs-on: ubuntu-${{ ubuntu-version }} # is Ubuntu environment
# ... some other config ...
steps:
- # ... some prepare steps, like action/checkout, run some script without MySQL, etc.
- name: Shutdown Ubuntu MySQL (SUDO)
run: sudo service mysql stop # Shutdown the Default MySQL, "sudo" is necessary, please not remove it
- # ... some steps before set-up MySQL ...
- name: Set up MySQL
uses: mirromutth/[email protected]
with:
# ... Set-up MySQL configuration, see Usage
- # ... some steps after set-up MySQL ...
# ... some another config ...License
This project is released under the MIT License.