ankane / setup-mysql Goto Github PK

View Code? Open in Web Editor NEW

22.0 3.0 6.0 51 KB

The missing action for MySQL

License: MIT License

JavaScript 100.00%

setup-mysql's Introduction

setup-mysql

The missing action for MySQL 🎉

Faster (with the default version) and simpler than containers
Works on Linux, Mac, and Windows
Supports different versions

Getting Started

Add it as a step to your workflow

      - uses: ankane/setup-mysql@v1

Versions

Specify a version

      - uses: ankane/setup-mysql@v1
        with:
          mysql-version: 8.0

Currently supports

Version	`8.0`	`5.7`
`ubuntu-22.04`	default
`ubuntu-20.04`	default
`macos-14`	default	✓
`macos-13`	default	✓
`macos-12`	default	✓
`macos-11`	default	✓
`windows-2022`	default	✓
`windows-2019`	default	✓

Test against multiple versions

    strategy:
      matrix:
        mysql-version: [8.0, 5.7]
    steps:
      - uses: ankane/setup-mysql@v1
        with:
          mysql-version: ${{ matrix.mysql-version }}

Options

Create a database

      - uses: ankane/setup-mysql@v1
        with:
          database: testdb

Extra Steps

Run queries

      - run: mysql -D testdb -e 'SELECT VERSION()'

Install time zone support

      - run: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

Related Actions

Contributing

Everyone is encouraged to help improve this project. Here are a few ways you can help:

Report bugs
Fix bugs and submit pull requests
Write, clarify, or fix documentation
Suggest or add new features

setup-mysql's People

Contributors

Stargazers

Watchers

Forkers

fettpet terryyin cairolee informaticacba jayanagunaweera01 jacyking

setup-mysql's Issues

mysql 5.7 not working anymore

thinking maybe needs to be mariadb now?

https://github.com/AtakamaLLC/notanorm/actions/runs/3422534560/jobs/5700058602

Ideas

Add user option
Add time-zone-support option - time-zone-support branch

Support set root password

Node.js 12 actions are deprecated on GH actions

See https://github.blog/changelog/2022-09-22-github-actions-all-actions-will-begin-running-on-node16-instead-of-node12/ for details.

Could you please update the action to use node16?

windows 2022, mysql 5.7

issue with windows 2022, mysql 5.7

https://github.com/AtakamaLLC/notanorm/actions/runs/4690819077/jobs/8314442573

MySQLdb.OperationalError: (1045, "Access denied for user 'runneradmin'@'localhost' (using password: NO)")

"runneradmin" user not set up with access

8.0 no longer working on windows-latest (2022)

Possibly due to this change? actions/runner-images#8398

https://github.com/tgstation/tgstation-server/actions/runs/6422137133/job/17470833198

2023-10-06T15:26:35.0706534Z ##[group]Run ankane/setup-mysql@v1
2023-10-06T15:26:35.0707152Z with:
2023-10-06T15:26:35.0707460Z env:
2023-10-06T15:26:35.0707799Z   TGS_DOTNET_VERSION: 6.0.x
2023-10-06T15:26:35.0708923Z   TGS_TEST_GITHUB_TOKEN: ***
2023-10-06T15:26:35.0709593Z   TGS_RELEASE_NOTES_TOKEN: ***
2023-10-06T15:26:35.0710080Z   WINGET_PUSH_TOKEN: ***
2023-10-06T15:26:35.0710588Z   PACKAGING_PRIVATE_KEY_PASSPHRASE: ***
2023-10-06T15:26:35.0711045Z   CODECOV_TOKEN: ***
2023-10-06T15:26:35.0711529Z   DOTNET_ROOT: C:\Users\runneradmin\AppData\Local\Microsoft\dotnet
2023-10-06T15:26:35.0712001Z   General__UseBasicWatchdog: true
2023-10-06T15:26:35.0712880Z ##[endgroup]
2023-10-06T15:26:35.3050122Z curl -Ls -o mysql.zip https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.32-winx64.zip
2023-10-06T15:26:40.2646979Z unzip -q mysql.zip
2023-10-06T15:26:53.5806609Z node:internal/fs/utils:351
2023-10-06T15:26:53.5807281Z     throw err;
2023-10-06T15:26:53.5807599Z     ^
2023-10-06T15:26:53.5808083Z 
2023-10-06T15:26:53.5809276Z Error: EEXIST: file already exists, mkdir 'C:\Program Files\MySQL'
2023-10-06T15:26:53.5810220Z     at Object.mkdirSync (node:fs:1414:3)
2023-10-06T15:26:53.5811223Z     at Object.<anonymous> (D:\a\_actions\ankane\setup-mysql\v1\index.js:73:6)
2023-10-06T15:26:53.5811980Z     at Module._compile (node:internal/modules/cjs/loader:1233:14)
2023-10-06T15:26:53.5812735Z     at Module._extensions..js (node:internal/modules/cjs/loader:1287:10)
2023-10-06T15:26:53.5813456Z     at Module.load (node:internal/modules/cjs/loader:1091:32)
2023-10-06T15:26:53.5814135Z     at Module._load (node:internal/modules/cjs/loader:938:12)
2023-10-06T15:26:53.5815102Z     at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:83:12)
2023-10-06T15:26:53.5815856Z     at node:internal/main/run_main_module:23:47 {
2023-10-06T15:26:53.5816556Z   errno: -4075,
2023-10-06T15:26:53.5817145Z   syscall: 'mkdir',
2023-10-06T15:26:53.5817777Z   code: 'EEXIST',
2023-10-06T15:26:53.5821588Z   path: 'C:\\Program Files\\MySQL'
2023-10-06T15:26:53.5822223Z }
2023-10-06T15:26:53.5822753Z 
2023-10-06T15:26:53.5823048Z Node.js v20.5.0
2023-10-06T15:26:53.6352003Z Cleaning up orphan processes

Thank You ♥️

Just saying thanks for solving an annoying problem (no mysql installed on the macos vms) so easily.