On 4/26/07, Michael Sullivan <[EMAIL PROTECTED]> 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------ -- [EMAIL PROTECTED] mailing list
