From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.62) (envelope-from ) id 1HhVF4-0007e9-67 for garchives@archives.gentoo.org; Fri, 27 Apr 2007 18:32:26 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.14.0/8.14.0) with SMTP id l3RIU1EI020160; Fri, 27 Apr 2007 18:30:01 GMT Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.239]) by robin.gentoo.org (8.14.0/8.14.0) with ESMTP id l3RIPufF015593 for ; Fri, 27 Apr 2007 18:25:57 GMT Received: by nz-out-0506.google.com with SMTP id 12so1202979nzp for ; Fri, 27 Apr 2007 11:25:56 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bEsqUd0TYMPGmbhVf9qFV2KsUjMTf1cfhUQSJtIjqwnjCToWwv9RatjSpSM4UBigXWa14jgEgH2ZSO5EggPA7lDmclLQ8ICcEF7GwKCfQcOZUj/Im4kvvca5KyUGzXbeaGTnnT327HnvuXrckuFeEESyCKWZB5Q7DfYAKv9wruE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ADrMCOk57kPzUeiVSo5zuxWJPcCj4yJlpTAJ4jeWZAJa4Qk0XC9isWTZ9amsD10pbswAI/frasEtAiQ0uA82OJLNMgXQM1UUoBntWRQFnp1ChkRi2AU+D8wusnnLliwgIXem5Ayqeb81tebOm04NjGo+u6JCdK4Nv5rIAQMZotM= Received: by 10.114.158.1 with SMTP id g1mr1097897wae.1177698356227; Fri, 27 Apr 2007 11:25:56 -0700 (PDT) Received: by 10.114.72.14 with HTTP; Fri, 27 Apr 2007 11:25:55 -0700 (PDT) Message-ID: <342e1090704271125o2cc39bffq99ca47f5a1c13bb3@mail.gmail.com> Date: Fri, 27 Apr 2007 15:25:55 -0300 From: "Daniel da Veiga" To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] OT - Migrating databases to a new box In-Reply-To: <1177623761.14916.2.camel@camille.espersunited.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1177623761.14916.2.camel@camille.espersunited.com> X-Archives-Salt: 8ad909cf-ace7-45cb-b2ee-1274f8dfdc63 X-Archives-Hash: d39c25122e0396e4824e489ee19b800b On 4/26/07, Michael Sullivan wrote: > I'm currently in the process of migrating databases to a new box. One > of my users has two databases that he needs access to. Is there a way > (through the mysql terminal interface) to find out what passwords he > uses to access these two databases? This will save me the trouble of > finding him. (Most of my users access remotely). I have root > priveleges. Thank you for your help. > -Michael Sullivan- > First, there's no way to know the passwords, because MySQL uses one-way encription. Second, if you have SUPER privileges , you can just dumb the whole server and import this into the new server (assuming same version and same .conf file). This method causes less errors (in my tests) but its a lot slower than disk copies... -- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------ -- gentoo-user@gentoo.org mailing list