MySQL configuration not honoured in shell

[liammcdermott]

Describe the bug

When services.mysql.settings.client has some values, such as database or socket, those settings are not used by the MySQL client in the devenv shell.

To reproduce

I was able to reproduce the issue in a new devenv project. Run devenv init, then use this devenv.nix:
https://gist.github.com/liammcdermott/9c92bdac1f2383c1601ce676316adebb

Run mysql and notice it is not using the configuration set in devenv.nix. For example, it should connect to the database using the correct socket path, but instead uses its own default.

This appears to be because the upstream package binary is taking precedence over scripts.mysql.exec in the PATH.

Workaround

Place this in the let bindings of devenv.nix:

  mysqlWrapped = pkgs.writeShellScriptBin "mysql" ''
    exec ${config.scripts.mysql.exec} "$@"
  '';

and this in the body of devenv.nix, inside enterShell:

export PATH="${mysqlWrapped}/bin":$PATH

Maybe this is the intended behaviour? It feels a bit sub-optimal to have to re-wrap the MySQL binaries though.

Version

devenv 1.1.0 (x86_64-linux)

I am not using Flakes.