Create the SSH tunnel
ssh -N root@SERVER_NAME -L 33061:127.0.0.1:3306
Connect to mysql remote server from localhost
mysql -uUSERNAME -h127.0.0.1 -P33061 -p
Don’t forget to create the mysql username with access from host 127.0.0.1
Create the SSH tunnel
ssh -N root@SERVER_NAME -L 33061:127.0.0.1:3306
Connect to mysql remote server from localhost
mysql -uUSERNAME -h127.0.0.1 -P33061 -p
Don’t forget to create the mysql username with access from host 127.0.0.1