Category Archives: mac

install mssql-tools on mac using brew

brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update brew install msodbcsql17 mssql-tools

Install brew install mysql@5.6 Start Start the MySQL service at login with: brew services start mysql Run Run the MySQL service but don’t start it at login (nor boot) with: brew services run mysql Stop Stop the MySQL service with: brew services stop mysql Restart Restart the MySQL service with: brew services restart mysql

bind address mysql on mac

edit : /usr/local/opt/mysql@5.5/homebrew.mxcl.mysql\@5.5.plist tambahkan <string>–bind-address=0.0.0.0</string> dibawah <string>–datadir=/usr/local/var/mysql</string>

mac terminal copy from file to clipboard

pbcopy < test.txt pbpaste pbpaste > paste.txt

netcat mac

nc -l 8888 testing : echo “ballack testing” | nc 127.0.0.1 8888

connect vnc from mac

1. open finder 2. press command + k 3. input url vnc://ipserver:port

tunnel

ssh -L 3318:localhost:3306 user@someipaddress ssh -L 2222:ipVpnEpt:22 user@ipnosrtobackup ssh -L *:3318:localhost:3306 -L *:7070:localhost:8080 user@someipaddress

path java mac

/usr/libexec/java_home /Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home/bin

set env mac

Bash : printenv echo $PATH temporary : export PATH=/coba/bin:$PATH permanen : vi ~/.bash_profile export PATH=/coba/bin:$PATH Zsh : vi ~/.zshenv export PATH=/coba/bin:$PATH