search for: mailfix

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: mailpswd=charlie 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....

...se 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: >> >> mailpswd=charlie >> >> 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 wil...

...ipt 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: > > mailpswd=charlie > > 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 $mail...