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
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
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
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
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@'%'