Package not found after installing

[vityachis]

Output of brew config

HOMEBREW_VERSION: 4.2.15
ORIGIN: https://github.com/Homebrew/brew
HEAD: 92a4311868322188478d7a90511ec0e8e6b0d7df
Last commit: 25 hours ago
Core tap JSON: 25 Mar 19:15 UTC
Core cask tap JSON: 25 Mar 19:15 UTC
HOMEBREW_PREFIX: /opt/homebrew
HOMEBREW_CASK_OPTS: []
HOMEBREW_MAKE_JOBS: 8
Homebrew Ruby: 3.1.4 => /opt/homebrew/Library/Homebrew/vendor/portable-ruby/3.1.4/bin/ruby
CPU: octa-core 64-bit arm_firestorm_icestorm
Clang: 15.0.0 build 1500
Git: 2.39.3 => /Library/Developer/CommandLineTools/usr/bin/git
Curl: 8.4.0 => /usr/bin/curl
macOS: 14.4-arm64
CLT: 15.3.0.0.1.1708646388
Xcode: 15.3
Rosetta 2: false

Output of brew doctor

Please note that these warnings are just used to help the Homebrew maintainers
with debugging if you file an issue. If everything you use Homebrew for is
working fine: please don't worry or file an issue; just ignore this. Thanks!

Warning: Some installed formulae are deprecated or disabled.
You should find replacements for the following formulae:
  [email protected]

Description of issue

Today I installed mysql-client using the command brew install mysql-client, but when I run the command mysql --version, I get the following error: zsh: command not found: mysql

Here is how looks my .zshrc file:

PROMPT='%B%F{green}%n@%m%f %F{yellow}%1~%f %F{7}%%%f%b '

export DOCKER_SCAN_SUGGEST=false
export GOROOT=/usr/local/go
export GOPATH=/usr/local/go/bin
export LDFLAGS="-L/opt/homebrew/opt/libpq/lib"
export CPPFLAGS="-I/opt/homebrew/opt/libpq/include"
export PATH=/opt/homebrew/opt/libpq/bin:$PATH
export PATH=/opt/homebrew/bin:$PATH
export PATH=/opt/homebrew/sbin:$PATH

Later, I found that the binary file is located at path: /opt/homebrew/opt/mysql-client/bin

Did I forget to add something to my .zshrc file?

Do I really need to specify something like export PATH=/opt/homebrew/opt/mysql-client/bin:$PATH for each package from the /opt/homebrew/opt/ folder? There are currently 81 packages located there.

Is there anything that can be done so that all previously installed packages, as well as all new packages that I can install, are available immediately?

[SMillerDev]

What does brew info MySQL-client say?

[vityachis]

==> mysql-client: stable 8.3.0 (bottled) [keg-only]
Open source relational database management system
https://dev.mysql.com/doc/refman/8.3/en/
/opt/homebrew/Cellar/mysql-client/8.3.0 (128 files, 151.7MB)
  Poured from bottle using the formulae.brew.sh API on 2024-03-25 at 11:57:16
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/m/mysql-client.rb
License: GPL-2.0-only with Universal-FOSS-exception-1.0
==> Dependencies
Build: bison ✘, cmake ✘, pkg-config ✘
Required: libevent ✔, libfido2 ✔, openssl@3 ✔, zlib ✔, zstd ✔
==> Caveats
mysql-client is keg-only, which means it was not symlinked into /opt/homebrew,
because it conflicts with mysql (which contains client libraries).

If you need to have mysql-client first in your PATH, run:
  echo 'export PATH="/opt/homebrew/opt/mysql-client/bin:$PATH"' >> ~/.zshrc

For compilers to find mysql-client you may need to set:
  export LDFLAGS="-L/opt/homebrew/opt/mysql-client/lib"
  export CPPFLAGS="-I/opt/homebrew/opt/mysql-client/include"
==> Analytics
install: 15,606 (30 days), 52,754 (90 days), 196,701 (365 days)
install-on-request: 14,636 (30 days), 48,101 (90 days), 176,433 (365 days)
build-error: 547 (30 days)

[SMillerDev]

mysql-client is keg-only, which means it was not symlinked into /opt/homebrew,
because it conflicts with mysql (which contains client libraries).

If you need to have mysql-client first in your PATH, run:
  echo 'export PATH="/opt/homebrew/opt/mysql-client/bin:$PATH"' >> ~/.zshrc

That's why it doesn't get added to your path by default. Only when the install warns you you need to add it to the path like this