Unable to create an additional user

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'@'localhost' IDENTIFIED
BY 'password';

but I get a 40032 error

Re: Unable to create an additional user

On 30 Jul, 01:28, "Nospam" 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'@'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?

Re: Unable to create an additional user

"Nospam" wrote in
news:vgari.2827$ie3.1041@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'@'localhost'
> IDENTIFIED BY 'password';
>
> but I get a 40032 error

you haven't specified a database

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