Hello, First all it is not recommended at all to dump and import user information.
Secondly the user authentication system has changed between 4.0 and 4.1 so old passwords from 4.0 wont work. Its given in the docs. Thirdly, MySQL does not store the actual password in its database. It always keeps a hash of the password and all the comparison are done against it. Karam --- [EMAIL PROTECTED] wrote: > Hello everyone, > > I'm working on migrating a number of users to a > different database > server. mysqldump makes this quite easy, but I've > run into a > surprising issue with the new server. > > I imported things like this: > > # mysqldump --skip-add-drop --all-databases | mysql > -h newbox -u root -p > > Somehow this didn't get the mysql.user table > correctly. So I dumped > that one seperately like this: > > # mysqldump --skip-add-drop --skip-extended mysql > user | mysql -h newbox -u root -p mysql > > > > Now I have all the users in the new mysql.user > table. But when I try > to login, the same credentials do not work. Both DB > servers are 4.1 > servers, one happens to be Debian and the other > RedHat. Both servers > have the wide password field and use old_password in > my.cnf. > > Any reason why these moved accounts are unable to > authenticate? > > > > -- > Ross Vandegrift > [EMAIL PROTECTED] > > "The good Christian should beware of mathematicians, > and all those who > make empty prophecies. The danger already exists > that the mathematicians > have made a covenant with the devil to darken the > spirit and to confine > man in the bonds of Hell." > --St. Augustine, De Genesi ad Litteram, Book II, > xviii, 37 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
