我正在尝试使用 sshpass 接收查询结果，示例如下:

sshpass -p password ssh user@ip "mysql -u user -pdbpassword -h ip -P port database -e \"SELECT * FROM database.ViewName;\"" 

import subprocess 
import sys 
from subprocess import check_output 
 
 
command = 'sshpass -p password ssh user@ip "mysql -u user -pdbpassword -h ip -P port database -e \"SELECT * FROM database.ViewName;\""' 
output = check_output(command, shell=True) 

bash: -c: línea 0: EOF inesperado mientras se buscaba un `"' coincidente 
bash: -c: línea 1: error sintáctico: no se esperaba el final del fichero 
/bin/sh: 1: : Permission denied 
Traceback (most recent call last): 
  File "ipcompare.py", line 8, in <module> 
    output2 = check_output(command2, shell=True) 
  File "/usr/lib/python2.7/subprocess.py", line 223, in check_output 
    raise CalledProcessError(retcode, cmd, output=output) 
subprocess.CalledProcessError: Command 'sshpass -p password ssh user@ip "mysql -u user -pdbpassword -h ip -P port database -e \"SELECT * FROM database.ViewName;\""' returned non-zero exit status 127 

请您参考如下方法:

我这样做是为了解决问题:

import subprocess 
import sys 
from subprocess import check_output 
 
 
command = 'sshpass -p password ssh user@ip "mysql -u user -pdbpassword -h ip -P port database -e \\\"SELECT * FROM database.ViewName;\\\""' 
output = check_output(command, shell=True)