SSH tunneling for MySQL

No forking in background and verbose

ssh -2 -v -c blowfish -C -N [email protected] -L 3370/127.0.0.1/3306

Forking in background

ssh -2 -f -c blowfish -C -N [email protected] -L 3370/127.0.0.1/3306

Creating a MySQL database and adding a user from CLI

mysql -uroot -p
mysql> CREATE DATABASE staff_hieraki;
mysql> GRANT ALL PRIVILEGES ON staff_hieraki.* TO staff@localhost IDENTIFIED BY 'password-goes-here' WITH GRANT OPTION;