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 ...

The MySQL query language works in that it constructs data records by selecting data from already existing data records. Many people use MySQL databases to power marketing and sales websites, ...