Storing output of MYSQL commmand in variable in UNIX Bash shell -

Storing output of MYSQL commmand in variable in UNIX Bash shell -

i having issue in storing output of mysql command in variable in unix bash shell

db_out= $(mysql -u$master_db_user -p$master_db_passwd -p$master_db_port -h$master_db_host -d$master_db_name<<enf show databases; enf) echo $db_out

i getting no output in variable $db_out.

can body suggest missing in above query?

having below output:

db_out= mysql -u$master_db_user -p$master_db_passwd -p$master_db_port -h$master_db_host -d$master_db_name --execute "show databases" + db_out= + mysql -uroot -paxway -p3306 -h10.151.14.248 -dsentinel --execute 'show databases' +--------------------+ | database | +--------------------+ +--------------------+ | information_schema | | composer | | mysql | | sentinel | | test | +--------------------+ echo "$db_out" + echo ''

it seems output written stderr.

try:

db_out= $(mysql -u$master_db_user -p$master_db_passwd -p$master_db_port -h$master_db_host -d$master_db_name 2>&1 <<enf show databases; enf)

or:

db_out= $( echo "show databases;" | mysql -u$master_db_user -p$master_db_passwd -p$master_db_port -h$master_db_host -d$master_db_name 2>&1)

unix