.github/workflows/main.yml in gizzard-0.7.1 vs .github/workflows/main.yml in gizzard-0.8.0

@@ -19,29 +19,20 @@
     strategy:
       fail-fast: false
 
       matrix:
         ruby:
-          - '2.6'
-          - '2.7'
           - '3.0'
           - '3.1'
         activerecord:
-          - '5.2'
           - '6.0'
           - '6.1'
           - '7.0'
-        exclude: # https://github.com/sue445/activerecord-compatible_legacy_migration/blob/master/.github/workflows/test.yml
-          - ruby: '2.6'
-            activerecord: '7.0'
-          - ruby: '3.0'
-            activerecord: '5.2'
-          - ruby: '3.1'
-            activerecord: '5.2'
+          - '7.1'
     services:
       mysql:
-        image: mysql:5.7
+        image: mysql:8
         ports:
           - 3306:3306
         env:
           MYSQL_ROOT_PASSWORD: ${{ secrets.MYSQL_ROOT_PASSWORD }}
           MYSQL_DATABASE: ${{ env.DB_NAME }}
@@ -61,17 +52,17 @@
       - name: Set up Ruby
         uses: ruby/setup-ruby@v1
         with:
           ruby-version: ${{ matrix.ruby }}
           bundler-cache: true
+          cache-version: 1
 
       - name: set MySQL sql_mode
         run: |
-          mysql --ssl-mode=DISABLE --protocol=tcp --host 127.0.0.1 --user=root --password=${{ env.DB_PASSWORD }} mysql <<SQL
+          mysql --ssl-mode=DISABLE --get-server-public-key --protocol=tcp --host 127.0.0.1 --user=root --password=${{ env.DB_PASSWORD }} mysql <<SQL
           SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';
-          SET GLOBAL character_set_server = 'utf8mb4';
-          SET GLOBAL innodb_file_per_table = 1;
-          SET GLOBAL innodb_large_prefix = ON;
+          SET GLOBAL character_set_server = 'latin1';
+          SET GLOBAL innodb_file_per_table = ON;
           SQL
 
       - name: set ENV
         run: |
           echo "DB_PORT=${{ job.services.mysql.ports[3306] }}" >> $GITHUB_ENV