I had that part. What I needed was a way to get in a script that worked. This script copyies files across a NFS connection to install and configure ssh, imap, mySQL, php, phpGroupware, Squid, Samba, name server, DHCP, and Webmin.
All I have to do is setup users for this particular box and fine tune it, which I do while it's burning in. :^) Linux Rocks ! ([EMAIL PROTECTED]) wrote*: > >And If you do: >mysql -uroot -ppassword > >it wont prompt you to type in the password > >Jamie > >On Wednesday 13 March 2002 14:14, you wrote: >> You can put any mysql command into a simple file, then: >> >> mysql [database] < filename >> >> >> -Rob >> >> On Wed, 2002-03-13 at 14:01, Kahli R. Burke wrote: >> > Bob Crandell wrote: >> > >mysql -u root -p >> > >mysql> create database phpgroupware ; >> > >mysql> grant all on phpgroupware.* to phpgroupware@localhost identified >> > > by 'password'; >> > >mysql> quit >> > > >> > >These are the lines to create a database and set a password. How would >> > > I put this in a shell script? I want it to run unattended, at least, >> > > almost unattended. >> > >> > Because mysql is an interactive program, you either need to use >> > something like expect to interact with mysql for you, or put the >> > commands into a file and give it to mysql on the command line. I can't >> > remember what the option is to pass ina file with SQL commands, but >> > it's in there. If you need to substitute strings for the password or >> > something, you might have to use a token in your file like '$password' >> > or something and use sed to replace it with the real desired password... >> > >> > Kahli > >
