Making an alias for SSH MySQL login using ENDSSH heredoc

Question

I want to make an alias that is kept in my bashrc file to log into a remote MySQL db via SSH. Assume that I can't add/alter any files on the remote machine that I'm SSHing into. Here's the relevant code.

function ssh_mysql {
  echo "SSHing to $server"
  ssh -t -t $suser@$server <<ENDSSH
    eval "mysql -h "$host" -u $user -p $pass $db"
ENDSSH
}
alias wt_mysql=ssh_mysql

The Problem: Entering 'wt_mysql' into the terminal as an alias SSHs and logs into MySQL fine.. but when trying to enter any command/query/etc at the MySQL prompt, none of what I've submitted is executed/run. Including the 'exit' command. I have to ctrl C to get back to my local terminal. although its a bit out of my understanding I believe the problem is related to this topic, Terminating SSH session executed by bash script
How can I make sure that mysql and any subsequent commands are executed remotely?
Thanks!

Why do you define function ssh_mysql and then alias wt_mysql=ssh_mysql instead of defining only function wt_mysql? I assume in my answer that you get the same problem running ssh_mysql as you do running wt_mysql, but if that is the case then why did you tell us about the alias? In general you should make it easy for people to help you by simplifying your question as much as possible. — dave4420
– dave4420, Commented May 2, 2013 at 8:53
Thanks for the solution. I was over thinking things.. I always intended this to be an alias so that it'd appear in the stdout with an alias command. My problem was that I had this funky password to contend with that had a | character. Adding my particular solution to the comments of your solution below. — sojojo
– sojojo, Commented May 9, 2013 at 20:14

dave4420 · Accepted Answer · 2013-05-02 07:34:10Z

4

I don't understand why you're using eval (or why you're passing the -t switch twice).

I would expect this ssh command to do what you want:

ssh -t $suser@$server "mysql -h '$host' -u $user -p $pass $db"

answered May 2, 2013 at 7:34

dave4420

47.2k6 gold badges121 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

chepner Over a year ago

I think -t is needed at least once (to run an interactive program over ssh); twice should be harmless.

dave4420 Over a year ago

@chepner Yes, -t is needed to allocate a terminal... I was confused about what the second -t was supposed to accomplish.

sojojo Over a year ago

Thanks again @dave4420 Here's what worked in my particular case of making an ssh+mysql alias:

function ssh_mysql(){ ssh -t $suser@$server "mysql -h "$host" -u "$user" --password='"$pass"' "$db"" } alias wt_mysql=ssh_mysql

Collectives™ on Stack Overflow

Making an alias for SSH MySQL login using ENDSSH heredoc

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related