Re: [PHP] It's Friday (a MySQL Question)
[email protected] ("Daniel P. Brown")
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
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. -- </Daniel P. Brown> UNADVERTISED DEDICATED SERVER SPECIALS SAME-DAY SETUP Just ask me what we're offering today! [email protected] || [email protected] http://www.parasane.net/ || http://www.pilotpig.net/