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

Come October 2023, MySQL 5.7 will no longer receive updates or security patches. It’s time to understand your options and plan for the path ahead. MySQL is the most popular open source database in the ...