I am using mysql 4.1 on a windows environment, and have so far been unable
to create a user to use with a particular database, other than the root user
I have tried:

use database;
GRANT SELECT, INSERT, UPDATE, DELETE TO 'username' [at] 'localhost' IDENTIFIED
BY 'password';

but I get a 40032 error

On 30 Jul, 01:28, "Nospam" <nos... [at] home.com> wrote:
> I am using mysql 4.1 on a windows environment, and have so far been unable
> to create a user to use with a particular database, other than the root user
> I have tried:
>
> use database;
> GRANT SELECT, INSERT, UPDATE, DELETE TO 'username' [at] 'localhost' IDENTIFIED
> BY 'password';
>
> but I get a 40032 error

I can find no information anywhere on a 40032 error.

Is there no other error text?

"Nospam" <nospam [at] home.com> wrote in
news:vgari.2827$ie3.1041 [at] newsfe3-gui.ntli.net:

> I am using mysql 4.1 on a windows environment, and have so far been
> unable to create a user to use with a particular database, other than
> the root user I have tried:
>
> use database;
> GRANT SELECT, INSERT, UPDATE, DELETE TO 'username' [at] 'localhost'
> IDENTIFIED BY 'password';
>
> but I get a 40032 error

you haven't specified a database

GRANT SELECT,INSERT,UPDATE,DELETE ON dbname.* TO