Sébastien Barbieri's blog

Just a reminder for myself…
After any mysql upgrade run from the terminal:
sudo mysql_upgrade (mac/*nix)
or
mysql_upgrade.exe (windows)

ssh -L 3307:localhost:3306 <user>@<remotehost> -f sleep 10; mysql -u <mysqluser> -p -P3307 -h 127.0.0.1

ssh -L 3307:localhost:3306 –> create a 3307 listening port locally that will be forwarded to a 3306 port on the other end of the ssh tunnel
<user>@<remotehost> –> user allow to connect via ssh on the remote host
-f –> go in background
sleep 10 [...]