On Fri, 2010-08-13 at 18:14 -0400, Daniel P. Brown wrote: > On Fri, Aug 13, 2010 at 17:59, Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx> wrote: > > > > echo 'password' | mysql -u root -p < query > > If you're going to do the password in plain text from the command > line like that (which is a bad idea), you don't need to pipe an echo. > Just type: > > mysql -u root -ppassword < query > > As long as there's no space between the -p flag and your password, > you're good to go. Still, not only is it a horrible idea, it's far > worse if it's your MySQL root. Far, far, FAR worse if it's the same > as your system root. You belong in jail --- no, *hell* --- if the > MySQL and system root passwords are the same, and you have remote root > login enabled with password authentication. > To both David and Daniel, thank you! How on earth I ever missed that argument before is a wonder known only to the great electronic deity in the sky! Thanks, Ash http://www.ashleysheridan.co.uk
