INSTALLATION OF DB
CLIENTS
on
MacOS
Document Ver. 0.01
Author : Avinash Kumar Behera
([email protected])
HOW TO INSTALL MYSQL CLIENT TO CONNECT TO REMOTE
MYSQL HOST FROM LOCAL.
1. Install Homebrew if you haven't already: /usr/bin/ruby -e "$(curl -fsSL
https://raw.githubusercontent.com/Homebrew/install/master/install)"
2. Run brew install mysql to install the MySQL client.
*Adjust version to check backward compatibility
Eg: mysql -u username -h remote_host_ip –P port –p
mysql -u avinashb -h 10.10.10.10 -P 3306 –p
HOW TO INSTALL MONGODB CLIENT TO CONNECT TO REMOTE
MONGODB HOST FROM LOCAL.
1. Install Homebrew if you haven't already: /usr/bin/ruby -e "$(curl -fsSL
https://raw.githubusercontent.com/Homebrew/install/master/install)"
2. Run brew tap mongodb/brew
brew update
brew install mongodb-community
*Adjust version to check backward compatibility
Eg. mongosh "mongodb://remote_host_ip:27017”
Mongosh “mongodb://10.10.10.10:27017”
HOW TO INSTALL REDIS CLIENT TO CONNECT TO REMOTE REDIS
HOST FROM LOCAL.
3. Install Homebrew if you haven't already: /usr/bin/ruby -e "$(curl -fsSL
https://raw.githubusercontent.com/Homebrew/install/master/install)"
4. Run brew install redisto install the redis client.
*Adjust version to check backward compatibility
Eg: redis-cli -h <hostname|ip> -p <port>
redis-cli -h 10.10.10.10 -p 6379
NOTE: Please feel free to install any client that suits you best. However, refrain from
requesting server access or asking others to retrieve data from the databases on your
behalf, unless it's strictly necessary for production data. For anything related to
production data and databases, all requests should go through a JIRA ticket.
