Re: [gentoo-user] putting mysql databases from one system to another

[Josh]

On Tue, Apr 5, 2011 at 11:59 AM, <covici@××××××××××.com> 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
>         covici@××××××××××.com
>
> 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.


-- 
()  The ASCII Ribbon Campaign - against HTML Email,
/\  vCards, and proprietary formats.