[oclug] MySQL Question

[rgiffin at cangurus.com]

Just delete the passwords as root, then re-assign them.  And yes, you can just transfer the files to the new installation.

Rod.

On Fri, 23 February 2001, Collin McCrank wrote:
> 
> Does anyone know if there is a way to find out a user password in
> MySQL?  I can get in using the root account but there are a couple of
> users that I need to find out the password for.
> 
> The reason I am asking is I have to totally rebuild this machine and the
> person who set it up before is no longer employed by us and doesn't
> remember the passwords.   The programs that he created need to access
> mysql and need passwords.
> 
> I have backed up the mysql databased with tar.  Is there a way for me to
> just import these databases, passwords and all into a new installation?
> 
> Thanks
> Collin