通过ssh运行mysql命令

Question

我在远程服务器上设置了一个自动日志检查的设置。我创建了类似这样的方法，使用exec命令跟踪日志…

Process p = Runtime.getRuntime().exec("ssh <user>@<domain> tail -f /location/logs

List<String> cmd = Arrays.asList("ssh user@domain mysql -u user -ppassword -h ipaddress", "use database", "SELECT column1, column2, etc FROM database");
    Process dumpcapProcess = Runtime.getRuntime().exec(cmd.toArray(new String[]{}));

    String line;
    // Reading the InputStream stream 
    BufferedReader reader = new BufferedReader(new InputStreamReader(dumpcapProcess.getInputStream()));
    while ((line = reader.readLine()) != null) {
        System.out.println(line);

    }

    // Reading the error stream for debug
    reader = new BufferedReader(new InputStreamReader(dumpcapProcess.getErrorStream()));
    while ((line = reader.readLine()) != null) {
        System.out.println(line);

List<String> cmd = Arrays.asList("ssh", "user@domain", "mysql", "-u",  "user", "-ppassword", "-h", "ipAddress", "use databases", "SELECT columns FROM database");

如何运行mysql命令将结果返回到eclipse终端？

Answer 1

可以使用-e参数直接从命令行传递查询。示例：

 mysql -uuser -ppass -hhost -Ddatabase -e'show tables'

这是未经测试的，但它应该类似于：

List<String> cmd = Arrays.asList(
    "ssh",
    "user@domain",
    "mysql",
    "-uuser",
    "-ppassword",
    "-h10.0.0.1",
    "-Ddb",
    "-e'SELECT columns FROM table'"
);