A MySQL cloud server only allows remote access to a certain server (in this example, 11.22.33.44). Running the following commands from the terminal is verified to work:
ssh -p 40000 [email protected]
mysql -u dbuser -p -h example.com
But when combining them into command (in order to assign it to an alias), it doesn't work:
ssh -p 40000 [email protected] "mysql -u dbuser -p -h example.com"
No error message is displayed, and the terminal never outputs a returned response.
Any ideas?
Try adding a "-t" to your ssh command (as in ssh -t -p 40000). That lets SSH interpret TTY commands like "stop echo for typing in the password", etc.