Re: It's Friday (a MySQL Question)

On Fri, Aug 13, 2010 at 17:59, Ashley Sheridan <ash@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.brown@parasane.net || danbrown@php.net http://www.parasane.net/ || http://www.pilotpig.net/