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 ...
A quick, step-by-step guide to setting up, configuring, and managing a MySQL database server on Windows, Linux, and macOS. Long a staple of open source computing, MySQL serves as the database back end ...