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?
Best Answer
According to the docs
prompts for a password, executes the given command, and returns to the shell (no logout required).
If you instead want your own prompt you need to script it:
Please note that there must be no space between
-p
and$pwd
becausemysql
then considers$pwd
to be the database's name.I would not recommend that because the password is then shown in cleartext in the terminal whereas
mysql -p
shows asterisks instead.