Josh <[email protected]> wrote:
> On Tue, Apr 5, 2011 at 11:59 AM, <[email protected]> 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
> > [email protected]
> >
> > 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
[email protected]
