I'd like to execute a mysql script where the user is asked to enter the password dynamically from the command line, if possible with a message
Enter your $root password.
However it doesn't work as expected. So far I have
mysql -u root -p CREATE DATABASE IF NOT EXISTS Test
moreover when the db is created how to logout from mysql and go back to bash commands?