Command working on shell but not with grunt-exec

[ali-faizan]

Command working on shell but not with grunt-exec

[gwicksted]

I assume you're using ES6 template strings to fill in the variables so I created a test below that outputs the expected string.

Looks like MySQL might be getting a double-quote inside the query causing the error you mentioned. Perhaps you have an escaped double-quote in your command or your user/password/database have values that require further escaping?

    // within "exec:" task
    test_mysql_ticket: {
      cmd: function () {
        var DB_USER = "abc";
        var DB_PASSWORD = "password";
        var DATABASE = "database-with-dashes";
        return `echo mysql -u "${DB_USER}" -p"${DB_PASSWORD}" -e "CREATE DATABASE IF NOT EXISTS \`${DATABASE}\`;"`;
      },
      callback: function(err, stdout, stderr) {
        console.log('stdout: ' + stdout);
        if ((stdout + "").trim() !== 'mysql -u "abc" -p"password" -e "CREATE DATABASE IF NOT EXISTS `database-with-dashes`;"') {
          grunt.log.error("Unexpected result: " + stdout);
          return false;
        }
      }
    }

[gwicksted]

Could not reproduce