Re: [PHP] It's Friday (a MySQL Question)

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

> On Fri, Aug 13, 2010 at 17:59, Ashley Sheridan <[email protected]> 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