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 1Q7C5L-0003MP-Lq for garchives@archives.gentoo.org; Tue, 05 Apr 2011 19:38:47 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id C99F21C008; Tue, 5 Apr 2011 19:37:19 +0000 (UTC) Received: from wlym.com (wlym.com [66.135.63.43]) by pigeon.gentoo.org (Postfix) with ESMTP id 9822F1C008 for ; Tue, 5 Apr 2011 19:37:19 +0000 (UTC) Received: from ccs.covici.com (pool-96-247-205-118.clppva.fios.verizon.net [96.247.205.118]) (authenticated bits=128) by wlym.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id p35JbHJT025203 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Tue, 5 Apr 2011 14:37:18 -0500 Received: from ccs.covici.com (localhost [127.0.0.1]) by ccs.covici.com (8.14.4/8.14.4) with ESMTP id p35JbDbZ008492 for ; Tue, 5 Apr 2011 15:37:16 -0400 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] putting mysql databases from one system to another In-reply-to: References: <7679.1302029984@ccs.covici.com> Comments: In-reply-to Josh message dated "Tue, 05 Apr 2011 12:13:05 -0700." X-Mailer: MH-E 8.2; nmh 1.3; GNU Emacs 23.3.1 Date: Tue, 05 Apr 2011 15:37:13 -0400 Message-ID: <8490.1302032233@ccs.covici.com> From: covici@ccs.covici.com 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 X-Archives-Salt: X-Archives-Hash: b6aa5b394bd60cbf6a6705dc21a1254c Josh wrote: > 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. It should be localhost in all cases. The mysql versions are 5.1.53 in both cases. I am trying to login with the mysql client and I can do it on the old box, but not the new one --same host name, etc. Now I can login with the root password on the new box, maybe that is stored somewher else. -- 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