wp-cli-tests icon indicating copy to clipboard operation
wp-cli-tests copied to clipboard
verified publisher icon wp-cli

Replace sql v8.0.4+ unsupported mysql_native_password plugin with suppored caching_sha2_password plugin

Open aaln opened this issue 1 year ago • 1 comments

Bug Ticket: https://github.com/wp-cli/ideas/issues/194

This PR should fix the composer prepare-tests command issue on the wp-cli-dev repo existing for anyone running sql version 8.0.4+

aaln avatar Sep 17 '24 18:09 aaln

While this PR resolves the issue on a fresh install, if mysql has an existing TEST_USER with mysql_native_password set as its auth plugin behat will fail after and upgrade to mysql 9.0.

I believe we could potentially detect this by querying for the user. However I'm not sure if:

  1. That's in scope of this PR.
  2. It's truely neccessary, since updating users with mysql_native_password would should be part of the mysql 9.0 upgrade process.

ohryan avatar Sep 17 '24 23:09 ohryan

Let's try this and then we can follow-up with a new PR if needed 👍

swissspidy avatar Oct 01 '24 13:10 swissspidy