mysqld uses local /usr/lib/plugins rather than nix ones

[jefft]

What happened?

When mysqld starts, I get a bunch of odd warnings:

mysqld: Can't open shared library '/usr/lib/mysql/plugin/component_reference_cache.so' (errno: 0 /usr/lib/mysql/plugin/component_reference_cache.so: cannot open shared object file: No such file or directory)
mysqld: Cannot load component from specified URN: 'file://component_reference_cache'.                                                                                                                                                   
2025-02-17T15:45:48.699464Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2025-02-17T15:45:48.699572Z 0 [System] [MY-010116] [Server] /home/jturner/src/github.com/jetify-com/devbox/examples/databases/mysql/.devbox/nix/profile/default/bin/mysqld (mysqld 8.0.36) starting as process 2883879
2025-02-17T15:45:48.700953Z 0 [ERROR] [MY-010342] [Server] Can't read from messagefile '/usr/share/mysql/english/errmsg.sys'
2025-02-17T15:45:48.701297Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/charset/collation/rules/import'.       
2025-02-17T15:45:48.701305Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'.
2025-02-17T15:45:48.701327Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/charset/collation/rules/import'.       
2025-02-17T15:45:48.701334Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'.
2025-02-17T15:45:48.701352Z 0 [Warning] [MY-000090] [Server] Unknown LDML tag: 'charsets/charset/collation/rules/import'.       

I happen to have mariadb installed in /usr/lib/mysql. It appears that the system-wide /usr is being used instead of the Nix-provided one.

Steps to reproduce

This can be seen in any project using mysql, e.g.:

$ cd ~/src/github.com/jetify-com/devbox/examples/databases/mysql
$ devbox run mysqld --verbose --help | grep /usr
2025-02-17T15:49:14.815119Z 0 [ERROR] [MY-010342] [Server] Can't read from messagefile '/usr/share/mysql/english/errmsg.sys'
basedir                                                      /usr/
character-sets-dir                                           /usr/share/mysql/charsets/
language                                                     /usr/share/mysql/
lc-messages-dir                                              /usr/share/mysql/
plugin-dir                                                   /usr/lib/mysql/plugin/

Command

No response

devbox.json

Devbox version

0.14.0

Nix version

nix (Nix) 2.18.5

What system does this bug occur on?

macOS (Intel)

Debug logs

No response