From owner-freebsd-questions@FreeBSD.ORG Thu Oct 2 19:01:10 2008 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 644D61065686 for ; Thu, 2 Oct 2008 19:01:10 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (gate6.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id DBB8C8FC1D for ; Thu, 2 Oct 2008 19:01:09 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [IPv6:::1]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.3/8.14.3) with ESMTP id m92J11xq095214; Thu, 2 Oct 2008 20:01:02 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.7.2 smtp.infracaninophile.co.uk m92J11xq095214 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=infracaninophile.co.uk; s=200708; t=1222974062; bh=j8nOoRLF4qZ+jY 4EY2OnqvgCJDxE4VX339AR8zK8THc=; h=Message-ID:Date:From:MIME-Version: To:CC:Subject:References:In-Reply-To:Content-Type:Cc:Content-Type: Date:From:In-Reply-To:Message-ID:Mime-Version:References:To; z=Mes sage-ID:=20<48E51A66.7050507@infracaninophile.co.uk>|Date:=20Thu,=2 002=20Oct=202008=2020:00:54=20+0100|From:=20Matthew=20Seaman=20|Organization:=20Infracaninophile|User -Agent:=20Thunderbird=202.0.0.17=20(X11/20080929)|MIME-Version:=201 .0|To:=20Andrei=20Brezan=20|CC:=20questions@fr eebsd.org|Subject:=20Re:=20Mysqldump=20password=20issue|References: =20<48E500EC.9010100@gmail.com>|In-Reply-To:=20<48E500EC.9010100@gm ail.com>|X-Enigmail-Version:=200.95.6|Content-Type:=20multipart/sig ned=3B=20micalg=3Dpgp-sha256=3B=0D=0A=20protocol=3D"application/pgp -signature"=3B=0D=0A=20boundary=3D"------------enigC27C910D028914A8 431440D3"; b=otb79gCdSRqCW8vMX9S/lQ1OaAbPXjobvC3dShsxdEu1IWLZ/8SPGt c4v4TQ2trWHwqXd0jvrGqe39F/NhLJNxDQOdbIwyvsz8yOIBY0OESEvta4bFBecX8zm JqZQr7F1pm+eJILq8LOuMwu7TQmVeG0eRl2BRqy7NmriqYG95g= Message-ID: <48E51A66.7050507@infracaninophile.co.uk> Date: Thu, 02 Oct 2008 20:00:54 +0100 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.17 (X11/20080929) MIME-Version: 1.0 To: Andrei Brezan References: <48E500EC.9010100@gmail.com> In-Reply-To: <48E500EC.9010100@gmail.com> X-Enigmail-Version: 0.95.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enigC27C910D028914A8431440D3" X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (smtp.infracaninophile.co.uk [IPv6:::1]); Thu, 02 Oct 2008 20:01:02 +0100 (BST) X-Virus-Scanned: ClamAV 0.94/8372/Thu Oct 2 16:21:47 2008 on happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-3.0 required=5.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,NO_RELAYS autolearn=ham version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on happy-idiot-talk.infracaninophile.co.uk Cc: questions@freebsd.org Subject: Re: Mysqldump password issue X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 02 Oct 2008 19:01:10 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigC27C910D028914A8431440D3 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Andrei Brezan wrote: > Hello list, >=20 > I wanna do a > mysqldump -u user -ppasswd --all-databases > backup.sql >=20 > and all I get is > mysqldump: No match. >=20 > 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. >=20 > 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. >=20 > If anyone has any ideea please let me know about it. > I mention that i use Freebsd 7_0 and mysql 5.0.67 >=20 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:@#~+=3D-_^%., 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. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW --------------enigC27C910D028914A8431440D3 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREIAAYFAkjlGm0ACgkQ8Mjk52CukIxeZQCfbNly1kruTqDuck61u+qYsf5x KekAoIu2lyfWgLMWoaMe9Np/Qi7aJaqw =aqwv -----END PGP SIGNATURE----- --------------enigC27C910D028914A8431440D3--