It is possible to install only the MySQL client on your MacOS using Homebrew. You would simply have to run the following command:
brew install mysql-client
Next, if you want the MySQL client to be available in any terminal path, you would need to put it in the PATH. To do this you have this other command:
echo ‘export PATH=”/opt/homebrew/opt/mysql-client/bin:$PATH”‘ >> ~/.zshrc
That taking into account that your system uses a shell based on zsh (all macos from Catalina). If this were not the case, surely when you finish installing the MySQL client you will see a message indicating the command you have to run to put it on the path.
The same MySQL client is used to connect with MariaDB management systems, so with this same process you can connect with both database engines.