ssh control socket port foward

ssh socket.md

SSHでcontrol socketを利用したport foward

• mysql hostをport foward

ssh -M -S ctl_path -Nf -L 33306:db-instance:3306 [email protected] -i ~/.ssh/aws.pem

• control socketをチェック

ssh -S ctl_path -O check [email protected]

• control socketを終了

ssh -S ctl_path -O exit [email protected]

おまけ: mysqlの結果を配列で受け取る

result=$(mysql -u user -h 127.0.0.1 -P 33306 -ppass dbname -N -se "SELECT id, name FROM member LIMIT 1")
IFS=$'\t' read -ra columns <<< result
echo "id: ${columns[0]}"
echo "name: ${columns[1]}"