Simple - brilliant. I've modified to cat a temporary script...
1) cat the file as suggested:
cat ~/payload/scripts/create_mysqldb.sql EOF
###---
### Display the current user
###---
create database puppet;
###---
### Display all default accounts
###---
USE puppet;
###---
### Remove
Hey all,
I've found many packages that sit on top of MySQL for various clients.
For the purposes of consistency I'd like to automate these installs.
I've been directed towards using .sql files and they work great.
The trouble I'm having now is that I would like to secure the
installation
...@ssiresults.com
To: mysql@lists.mysql.com
Subject: Variable Expansion Using MySQL Client and .sql Files
Hey all,
I've found many packages that sit on top of MySQL for various clients.
For the purposes of consistency I'd like to automate these installs.
I've been directed towards using .sql files