[CentOS] Using environment variables in mariadb

Tue Mar 14 21:53:01 UTC 2017
Robert Moskowitz <rgm at htt-consult.com>

I want to script a rather simple create database operation.  Thing is, I 
have to provide the password for that database.  I would like to do this 
with an environment variable, but the simple approach dose not work:


mysql -u root -p

CREATE USER 'mailfix'@'localhost' IDENTIFIED BY $mailpswd;
GRANT ALL PRIVILEGES ON `mailfix` . * TO 'mailfix'@'localhost';

Of course the mysql command needs the mysql root password, but that is 
as expected.  But mysql will not process $mailpswd, not surprisingly.

I know I could create a file with these commands, sed the password into 
the file, then pipe thr file into mysql.  I would rather do this 
directly without a temp file.