Percona Toolkit 3.6.0 Usage Issue with MySQL Client 9.0 on Mac OS Sonoma

Polyglot Projects Percona Toolkit
,
2

Hello @brianestrada658,
We, Percona, do not manage the homebrew formula. We did not create it, we don’t manage it. Looking at the code, I see this line, homebrew-core/Formula/p/percona-toolkit.rb at a10991ef8325587a6b0b089e484045214aeccc08 · Homebrew/homebrew-core · GitHub, which requires mysql-client, it makes no indication of neding mysql 9. I know for certain that the toolkit itself does not have this dependency.

Answers:

  1. Install the toolkit manually from the .tar.gz from our website.
  2. All brew formulas are on github. Simply look through the git history for the version you want.
  3. The brew formula should be satisfied with any mysql version according to the code line above. I would ask in the homebrew support channels how to specify mysql 8.0, you don’t even need 8.4.
  4. mysql 9.0 does not support mysql_native_plugin at all. it was removed. you have no choice other than the sha2. If you are not using 9.0, then 8.0 an 8.4 should support native_password.

Try uninstalling the toolkit, and mysql. then install mysql8 first, then the toolkit. maybe that will work.

1 Like