Re: Migrating MySQL users

2005-09-05 Thread ross
On Mon, Sep 05, 2005 at 11:00:43AM -0700, Karam Chand wrote: > First all it is not recommended at all to dump and > import user information. Why not? They are just entries in a database, like any other. How would you propose I move a large batch of users to another database server? > Secondly

Re: Migrating MySQL users

2005-09-05 Thread ross
On Mon, Sep 05, 2005 at 12:41:50PM +0300, Gleb Paharenko wrote: > Hello. > > Have you run 'FLUSH PRIVILEGES'? Doh! I got everything else find, but forgot something stupid. Murphy's law, I suppose. Thanks for the prompt! Ross -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Migrating MySQL users

2005-09-05 Thread Karam Chand
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 kee

Re: Migrating MySQL users

2005-09-05 Thread Gleb Paharenko
Hello. Have you run 'FLUSH PRIVILEGES'? [EMAIL PROTECTED] wrote: > On Sun, Sep 04, 2005 at 10:08:32PM -0400, [EMAIL PROTECTED] wrote: >> Now I have all the users in the new mysql.user table. But when I try >> to login, the same credentials do not work. > > A bit more info on this. T

Re: Migrating MySQL users

2005-09-04 Thread ross
On Sun, Sep 04, 2005 at 10:08:32PM -0400, [EMAIL PROTECTED] wrote: > Now I have all the users in the new mysql.user table. But when I try > to login, the same credentials do not work. A bit more info on this. This interesting error happens with GRANT: mysql> grant all on testing.* to testing@'%'