Bash check if mysql command failed

Question

I have the following bash script:

MYSQL="which mysql"
SQL="CREATE DATABASE IF NOT EXISTS TEST;"

read -p -s "Enter mySQL password:" DBPASS

$MYSQL -root -p$DBPASS -e "$SQL"
if [ "$?" -eq 0 ]; 
then
   echo "Failed."
else
   echo "Done."
fi

Even if I type wrong password the script says "Done.", as it can´t detect the mysql command error...

I need to be able to correctly show the "Error." message when someone types a wrong password.

Help appreciated.

Perhaps using expect - expect.sourceforge.net - would be a better bet — Ed Heal
– Ed Heal, Commented Oct 31, 2015 at 11:08
if "which mysql" found mysql so it is not necessary to do it. mysql also search in the $PATH and if you want to use you put it in backticks MYSQL=which mysql and the MySQL username must after -u. so -uroot — Bernd Buffen
– Bernd Buffen, Commented Oct 31, 2015 at 12:14

Ed Heal · Accepted Answer · 2015-10-31 11:20:57Z

5

$? == 0 means the command run successfully.

try this:

MYSQL="which mysql"
SQL="CREATE DATABASE IF NOT EXISTS TEST;"

read -p -s "Enter mySQL password:" DBPASS

$MYSQL -root -p$DBPASS -e "$SQL"
if [ "$?" -eq 0 ]; 
then
   echo "Done."
else
   echo "Failed."
fi

edited Oct 31, 2015 at 11:20

Ed Heal

60.3k18 gold badges90 silver badges137 bronze badges

answered Oct 31, 2015 at 11:14

Fujiao Liu

2,2732 gold badges25 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hafenkranich Over a year ago

use: export phppath=$(which php) echo $phppath and add a newline before the echo

Collectives™ on Stack Overflow

Bash check if mysql command failed

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related