On Tue, Apr 5, 2011 at 2:37 PM, <cov...@ccs.covici.com> wrote:
> > Josh <korth...@gmail.com> wrote: > > > On Tue, Apr 5, 2011 at 11:59 AM, <cov...@ccs.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 > > > cov...@ccs.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. > 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 > cov...@ccs.covici.com > > I hate to ask the obvious, but are you passing "-u <username> and -p" to mysqldump? the "-p" by itself will prompt for a password, which you will then enter. The format should be "mysqldump databasename -u username -p > file", then enter the password at the "Password:" prompt.
