wp-cli cannot connect to a MySQL database in GitHub Actions setup (but works on local machine)

[vadimkantorov]

How to set up properly WordPress in a GitHub Actions env using wp-cli?

(Usecase for context: I am exploring usage of WP as a static site generator runnable on GitHub Actions (similar to Jekyll: basically I'd like to have all WP settings and content in file system, then a WP install, then export static copy of the website). Setting it up is the first step. Some of my workable instructions for local runs are at https://github.com/vadimkantorov/wpssg )

Maybe somehow need to ask it to pass some analog of -h 127.0.0.1 for connecting to MySQL, but how (theoretically DB_HOST setting done in wp-config.php by ./wp-cli.phar config create should be enough)?

Thanks!

name: test

on: workflow_dispatch

jobs:
  test:
    runs-on: ubuntu-22.04
    steps:
      - uses: actions/checkout@v4

      - name: Prerequisites
        run: |
          sudo apt install php-cli php-mysql php-dom mysql-server sqlite3
          curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar
          curl -o composer.phar https://getcomposer.org/installer

      - name: Test
        run: |
          sudo service mysql start
          sudo mysql -h 127.0.0.1 --user=root --password=root <<< "CREATE USER 'wpssguser'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'wpssgpass';"
          sudo mysql -h 127.0.0.1 --user=wpssguser --password=wpssgpass <<< "SHOW DATABASES" # works fine

          php ./wp-cli.phar core download --locale=en_US
          php ./wp-cli.phar config create --locale=en_US --dbuser=wpssguser --dbpass=wpssgpass --dbname=wpssgdb --dbhost=127.0.0.1
          
          php ./wp-cli.phar db create # fails with ERROR 1044 (42000) at line 1: Access denied for user 'wpssguser'@'127.0.0.1' to database 'wpssgdb'

[vadimkantorov]

@danielbachhuber At filing time, I considered this issue as a bug report about GH Actions usage... Or was it looking like I'm doing sth wrong in the workflow script?

[vadimkantorov]

Basically, how do I init a local database with simple basic auth correctly on GH Actions for testing some WP stuff?