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]
