want to leave this list but I can not, can someone erase me from this list?
On Tue, Apr 5, 2011 at 23:08, Mark Shields <[email protected]> wrote: > On Tue, Apr 5, 2011 at 2:37 PM, <[email protected]> wrote: > >> >> 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] >> >> 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. -- Atenciosamente, Gregory Fontenele
