From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Q7Bhr-0000hL-GA for garchives@archives.gentoo.org; Tue, 05 Apr 2011 19:14:27 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 4125B1C074; Tue, 5 Apr 2011 19:13:06 +0000 (UTC) Received: from mail-px0-f179.google.com (mail-px0-f179.google.com [209.85.212.179]) by pigeon.gentoo.org (Postfix) with ESMTP id F28391C074 for ; Tue, 5 Apr 2011 19:13:05 +0000 (UTC) Received: by pxi2 with SMTP id 2so397648pxi.10 for ; Tue, 05 Apr 2011 12:13:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=CjTQD312jKKlxIFA2UgKOfFFircWsujdgGzNu8yNCpM=; b=kC1Sw1Yf9JTch2eD3+H2FiuFokNWzKdhViqY2USt5VtpAxPKZS4L7inOZ2IE8v4VGT /sGq62cMCRvAotjqnlerrbcVyZ3SIP6uqs1pezaOWQwSJxWfbfSYdBF6L89OZE+W7NSb sM9AMO9zQsywOjQfqFyU30QscR3FSHOBu0FC4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=g9mYvxfcv8a7uMq3THQtPx4+Sf+wvHzgVPg6RjuilosG0dt0uepN2XCQNgiQzpJi2N UbEtjCYXwFNe6B11nun72vtTXB8gTMxN8m/lGVVbkC9L4iU2IWLshq6O2vx5cdc8nb68 Vo9rgDl0ZC3yhM2R0i9MkdM/LQ48lWuRoCfRk= Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Received: by 10.142.171.2 with SMTP id t2mr28951wfe.339.1302030785079; Tue, 05 Apr 2011 12:13:05 -0700 (PDT) Received: by 10.68.71.200 with HTTP; Tue, 5 Apr 2011 12:13:05 -0700 (PDT) In-Reply-To: <7679.1302029984@ccs.covici.com> References: <7679.1302029984@ccs.covici.com> Date: Tue, 5 Apr 2011 12:13:05 -0700 Message-ID: Subject: Re: [gentoo-user] putting mysql databases from one system to another From: Josh To: gentoo-user@lists.gentoo.org Content-Type: multipart/alternative; boundary=000e0cd184a06e69f504a030aa16 X-Archives-Salt: X-Archives-Hash: 4c5000d354dfc09de71e84664b6353b1 --000e0cd184a06e69f504a030aa16 Content-Type: text/plain; charset=ISO-8859-1 On Tue, Apr 5, 2011 at 11:59 AM, wrote: > I am trying to copy my databases from one system to another and since > one is 32-bit and the other is 64-bit, I was told that I could not copy > the binary databases directly, but I had to do mysqldump and then > put that source file into the new system. What I am getting is that the > passwords seem not to have gotten through -- the user names seem to be > there, but I cannot login with the passwords the user had in the old > system. > > Can anyone tell me why this is so and what I can do to fix? > > Thanks in advance for any ideas. > > -- > Your life is like a penny. You're going to lose it. The question is: > How do > you spend it? > > John Covici > covici@ccs.covici.com > > Which two MySQL versions are in use here? Older versions of mysql used a different format for the passwords and there is a flag you need to pass to mysqld to get it to use old passwords (I believe) What is the connection string you are using? Specifically are you connecting via the mysql socket, using a hostname etc? Say the old server was called "foo.stuff.net" and the connection was made via the external interface e.g. "mysql -h foo.stuff.net", the user may have been setup to allow connections from "foo.stuff.net" only, as where now you may be connectin from "bar.stuff.net" or "localhost". SELECT user,host FROM mysql.user ORDER BY user; May shed some light on the situation for you. -- () The ASCII Ribbon Campaign - against HTML Email, /\ vCards, and proprietary formats. --000e0cd184a06e69f504a030aa16 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Tue, Apr 5, 2011 at 11:59 AM, <covici@ccs.covici.com&= gt; wrote:
I am trying to copy my databases from one system to another and since
one is 32-bit and the other is 64-bit, I was told that I could not copy
the binary =A0databases =A0 directly, but I had to =A0do mysqldump and then=
put that source file into the new system. =A0What I am getting is that the<= br> passwords seem not to have gotten through -- the user names seem to be
there, but I cannot login with the passwords the user had in the old
system.

Can anyone tell me why this is so and what I can do to fix?

Thanks in advance for any ideas.

--
Your life is like a penny. =A0You're going to lose it. =A0The question = is:
How do
you spend it?

=A0 =A0 =A0 =A0 John Covici
=A0 =A0 =A0 =A0 covici@ccs.covici= .com

Which two MySQL versions are in use here?
=A0= =A0 =A0 Older versions of mysql used a different format for the passwords a= nd there is a flag you need to pass to mysqld to get it to use old password= s (I believe)

What is the connection string you are using?=A0Specific= ally=A0are you connecting via the mysql socket, using a hostname etc?
=
=A0=A0 =A0 Say the old server was called "foo.stuff.net" and the connection was made via the exter= nal interface e.g. "mysql -h foo.stuf= f.net", the user may have been setup to allow connections from &qu= ot;foo.stuff.net" only, as where = now you may be connectin from "bar.st= uff.net" or "localhost".

SELECT user,host FROM mysql.user ORDER BY user;

May shed some light on the situation for you.


--
()=A0 The ASCII Ribbon Campaign - against HTML Email,<= br> /\=A0 vCards, and proprietary formats.
--000e0cd184a06e69f504a030aa16--