I'd like to execute a mysql script where 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?