Date: Thu, 2 Oct 2008 13:13:43 -0700 From: Fred Condo <fcondo@quinn.com> To: Andrei Brezan <andrei693@gmail.com> Cc: questions@freebsd.org Subject: Re: Mysqldump password issue Message-ID: <55808659-9401-4D7A-8565-D7851D8E1F0B@quinn.com> In-Reply-To: <48E51A66.7050507@infracaninophile.co.uk> References: <48E500EC.9010100@gmail.com> <48E51A66.7050507@infracaninophile.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
On Oct 2, 2008, at 12:00 PM, Matthew Seaman wrote: > Andrei Brezan wrote: >> Hello list, >> I wanna do a >> mysqldump -u user -ppasswd --all-databases > backup.sql >> and all I get is >> mysqldump: No match. >> This happens either i put --all-databases or I specify any of the >> databases. I want to do a backup as user root, that's why I use >> all-databases opt. >> If I use the command: >> mysqldump -u root -p --all-databases >backup.sql >> I get the password prompt, I type the passwd and everythig works >> great. >> It seems that there is a problem with -p, i've tried --password with >> same result. >> If anyone has any ideea please let me know about it. >> I mention that i use Freebsd 7_0 and mysql 5.0.67 > > My guess is that the password (which you've obviously elided) contains > characters of syntactic significance to the shell. Any of the > following > will lead to wailing and gnashing of teeth: > > * ? [ < > & ; ! | $ > > Probably others as well. The general way to get round this is to > put 'quote' marks around your password -- but this will only work if > the password is a separate word on the command line -- ie. whitespace > between it and any other tokens. I believe that the '-p' flag to > MySQL > is a bit painful in that regard as it doesn't allow whitespace between > itself and the password. Hmmm... untested, but it should work if you > just quote around the -p like so: '-ppassword'. > > Alternatively, just change the password to one containing less > troublesome characters: a-zA-Z0-9:@#~+=-_^%., I recommend use of > 'apg' to generate randomised but strangely memorable passwords. Oh, > and simply making the password longer makes it much more secure even > if you're limited to a relatively small alphabet. If consistent with your security policies, you can store the password in your ~/.my.cnf file: [client] user=db_user password=funny&password
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?55808659-9401-4D7A-8565-D7851D8E1F0B>