mysql - 如何在 Node.js 中为 Spawn Child_Process 提供密码

Question

我正在尝试使用 mysqldump 创建应用程序的 mysql 备份。生成子进程似乎无法写入密码。这些是我迄今为止尝试过的所有方法。

var spawn = require('child_process').spawn("mysqldump",
["-u", "Username", 
"DBName", 
">", "./Backup/DB_Backup.sql", 
"-p", "Password"]);

spawn.stdin.write("P");
spawn.stdin.write("a");
spawn.stdin.write("s");
spawn.stdin.write("s");
spawn.stdin.write("w");
spawn.stdin.write("o"); 
spawn.stdin.write("r");
spawn.stdin.write("d");
spawn.stdin.write("\n");

spawn.stdin.write("Password\n");

spawn.stdout.on('data', (data) => {
    console.log(`stdout: ${data}`);
    spawn.stdin.write("Password\n");
});

spawn.stderr.on('data', (data) => {
    console.log(`stderr: ${data}`);
});

spawn.on('close', (code) => {
    console.log(`child process exited with code ${code}`);
});

这个问题可能看起来重复，但没有一个答案对我有帮助。

Answer 1

将“-p”、“密码”替换为“-pPassword”

示例:

const { spawn } = require('child_process');

const mysqldump = spawn('mysqldump', [
    '-u', db.user,
    '-p' + db.password,
    db.database
]);