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 DATABASE mailfix;
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.