mysql 9.0 seems to be incompatible with mlwh

[amakunin]

Hi folks. I've just started testing the updated mgenv locally and have at least one issue to report:

When querying mlwh, I'm getting an error _mysql_connector.MySQLInterfaceError: Authentication plugin 'mysql_native_password' cannot be loaded: (then list of expected locations within my conda installation)

After some research, it seems that this native password auth method was disabled in MySQL v9.0 Homebrew/homebrew-core#180498 - but it is still used on mlwh server side.

mysql version update was introduced in mgenv v.6.0.1, so I've tested v.6.0.0 which has

  - mysql-common=8.3.0=h3829a10_5
  - mysql-libs=8.3.0=h01befea_5

And querying mlwh worked fine there

The latest version with native password support enabled seems to be 8.4

[alimanfoo]

Thanks @amakunin. FWIW I'd be happy to pin the mysql packages at 8.4. I think querying MLWH is the only thing we need these for, so good to maintain compatibility.