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.
--
</Daniel P. Brown>
UNADVERTISED DEDICATED SERVER SPECIALS
SAME-DAY SETUP
Just ask me what we're offering today!
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
