write command: Running mysql from ssh & query statement has a Text Header in the SELECT statement that needs quotes.

This project is actually so silly that I'll give you the solution right here (and explain). :P What ssh does is connect to server1 and run the command with a shell ... After being parsed by the local shell. That means all special symbols are going to be parsed twice. In a way, this is pretty much the same as running CMD vs. sh -c "CMD" What's left cannot work because you're using single quotes the wrong way. So 'SELECT 'Column 1 text' as 'Column 1 Heading', table1.* FROM table1;' will be parsed as, in python terms, ['SELECT Column', '1', 'text as Column', '1', 'Heading'], whereas it is expected to be a single monolithic string. What to do about this? The most simple fix is to explictly escape all shell-specific characters, eg. quotes, single quotes, semicolons etc, before passing them to the local shell. The trick is knowing which ones yes and which ones not. Your call would be fixed by using this instead: ssh server1 "mysql -u root -ppassword -e 'SELECT \"Column 1 text\" as \"Column 1 Heading\", table1.* FROM table1;' dataBase1" You can also try to use this function for more generic conversion: chars='[\"\ \t\&'\'']' function convertInputForSsh() { for i in "${@}"; do echo -n $(echo ${i} | sed -e "s,\(${chars}\),\\\\\1,g")\ ; done; } Example: CMD=(for i in 1 '2 3' '4 5' 6\; do echo \${i}\; done) > ssh server1 "${CMD[@]}" 1 2 3 4 5 6 vs. > ssh server1 $(convertInputForSsh "${CMD[@]}") 1 2 3 4 5 6

Hi there, I have over 7 years experience working on HTML, Wordpress, Magento, Database administration, OpenCart, Website Design, Logo / Banner Design Joomla, CSS and Linux Administration. I have read the project description very well, and i would like to complete this project. lets complete this project

A proposal has not yet been provided

Should really be an easy going quiz time :) I'd be glad to help, and I'm definitely sure I have the solution ;) Thank you.

I can help you to do this job right now. lets start. thanks ------------------------------------------------------------------------------------

Hi I have 3+ years experience in MySQL and Linux. I will help you sort this out. Please let me know if you are interested. Thanks

I usually do something like this and escape the command watching for asterisks and the like that the shell will try to interpret. echo "escaped_command" | ssh user@host $(< /dev/fd/0)

Hi, it should be: ssh server1 "mysql -u userName -ppassword -e 'SELECT \"Column 1 text\" as \"Column 1 Heading\", table1.* FROM table1;' dataBase1" Regretfully I do not have a linus at my disposal, so I hope you would be kind enough to award me the project if it works. Regards, Diego Sorry, didn't update the price.

I Could help you. . . .

Hi! Try this: ssh server1 "mysql -u userName -ppassword -e 'SELECT \"Column 1 text\" as \"Column 1 Heading\", table1.* FROM table1; dataBase1'" I tried to simulate a setup more or less the same on my laptop, and it worked for me when I used quotes ( " ) and escaped them with a backslash ( \ ). Hope that helps! Mark

A proposal has not yet been provided

I'm experienced in shell programming and with ssh - this is what I do everyday on my job. Here in Germany it's after midnight now, that's why i terminate this message with GOOD NIGHT :-)

Hi! I have a large experience in LAMP environments. I am new here on freelancer, so I want to gain reputation and get a good opinion from you.

I've done this before. Contact me and I'll teach you how to escape arguments with ssh, or with any unix command, for that matter.

working in linux,And handing the servers over ssh and also handle the mysql database for the main website of the company.

I know what to do. Firstly, you must have permission to execute mysql on remote host. And Secondly, you have some mistakes in you command. It must be like this: ssh username@HOST "mysql -u root -e 'Select ''123'' as ''text'', users.* from users;' exim"