Bash script unable to send instructions to mysql

Question

This is part of a Bash script, and the inside looks like this:

createdbcmd="docker exec $1 mysql -v -uroot -e \"GRANT ALL PRIVILEGES ON $dbname.* TO $2@$4 IDENTIFIED BY '$3'\"" 
echo $createdbcmd
$createdbcmd

the echo looks like this:

docker exec mysql_test_no mysql -v -uroot -e "GRANT ALL PRIVILEGES ON wordpress.* TO [email protected] IDENTIFIED BY 'changeme'"

Running this exact command works just fine. via the bash-script it acts as if i'm just running 'mysql' and i get the default help information with no error.

janos · Accepted Answer · 2014-12-20 19:28:59Z

2

Try this way:

createdbcmd="docker exec $1 mysql -v -uroot -e \"GRANT ALL PRIVILEGES ON $dbname.* TO $2@$4 IDENTIFIED BY '$3'\"" 
echo $createdbcmd
eval $createdbcmd

Without the eval, the quoted expression is not interpreted correctly.

answered Dec 20, 2014 at 19:28

janos

126k31 gold badges242 silver badges253 bronze badges

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

1 Comment

janos Over a year ago

@user3009620 Then please mark it as accepted! (See that pipe/check shaped icon below the voting arrows next to my post, on the left.)

Collectives™ on Stack Overflow

Bash script unable to send instructions to mysql

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