Issues with mysql command in bash script

Question

I'm really struggling with a bash command, trying to launch a mysql query :

output=$(mysql --user=root --password="$password" -s --execute 'grant all privileges on zabbix.* to zabbix@localhost identified by "$zabbix_pwd";')

The statement above does not work, because $zabbix_pwd is not take as a variable, as it should...

Any idea on how to rewrite this statement would be very helpful.

Cheers,

Raj.

Read about single vs. double quotes in Bash. – stephanmg Nov 26 '19 at 13:29 — stephanmg, Nov 26 '19 at 13:29

score 0 · Accepted Answer · answered Nov 26 '19 at 13:33

0

Your escaping is wrong. Please try this :

output=$(mysql --user=root --password="$password" -s --execute "grant all privileges on zabbix.* to zabbix@localhost identified by \"$zabbix_pwd\";")

Hope it helps.

answered Nov 26 '19 at 13:33

Matias Barrios

It does ! Thanks a lot for taking time in helping me :-) – Rajstopy Nov 26 '19 at 16:28

1 Answers1