[oclug] MySQL Question

[Collin McCrank]

Thanks, but I would need to keep the current passwords as they are needed by the programs that use mysql and I can't find
them.

So again, if I copy all the databases, even the mysql one which contains all the passwords, would the current passwords
migrate to the new installation.

-Collin

rgiffin at cangurus.com wrote:

> 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
>
> _______________________________________________
> oclug mailing list
> oclug at lists.oclug.on.ca
> http://www.oclug.on.ca/mailman/listinfo/oclug
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cmccrank.vcf
Type: text/x-vcard
Size: 333 bytes
Desc: Card for Collin McCrank
Url : http://tux.oclug.on.ca/pipermail/oclug/attachments/20010223/ebfcfacb/cmccrank.vcf