However, even though i specify no password on the command, the script does not wait for a user input and just carries on regardless and errors out. What would be a better, generic way of doing this ...

I have someone using WebMatrix to connect to a remote MySQL database. But they can only access the database over an SSH tunnel... so the connection goes something like this: This works with MySQLcc, ...