On Fri, 2010-08-13 at 18:14 -0400, Daniel P. Brown wrote:

> On Fri, Aug 13, 2010 at 17:59, Ashley Sheridan <a...@ashleysheridan.co.uk> 
> 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! 


Reply via email to