Trouble Creating New Users on MySQL

[Adam]

Hi,

I've installed MySQL on my own system running windows 2000 pro. I'm having trouble creating and accessing new users. I log in as root and I run a file called newuser.sql. It contains:

grant select
on db3.*
to memuser identified by 'samplepass';

from the command line i run> source newuser.sql

It seems to run fine but when I attempt to log in as memuser using the password I get "access denied". It seems the system sees the user but the password is not recognized. Does anyone know what I'm doing wrong?

Thanks,
Adam

[Musicman]

Hi,

at least on unix we are supposed to use username@localhost - and some of the error messages say so

Musicman

[Greg D.]

I've got MySQL and win2000 running as well, and as a rule, I create users with the @localhost as well, like this:

grant select on db3.* to memuser@localhost identified by 'samplepass';

I *believe* the @localhost is necessary to get to it *from the console* but that it might run fine otherwise.

Using the above statement, in any case, does let you log in to the console with that username and password.

Hope this helps,
Greg