Unable to create an additional user

3 Message(s) by 3 Author(s) originally posted in php sql

From: Nospam

Date: Sunday, July 29, 2007

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

1. <operating system> The {Unix} {superuser} account (with
	user name "root" and user ID 0) that overrides file
	permissions.  The term {avatar} is also used.  By extension,
	the privileged system-maintenance login on any {operating
	system}.

	See {root mode}, {go root}, {wheel}.

	[{Jargon File}]

	(1994-10-27)

	2. <operating system> {root directory}.

	(1996-11-21)

	3. <data> {root node}.

	(1998-11-14)

user
I have tried:

use database;
GRANT SELECT, INSERT, UPDATE, DELETE TO 'username'@xxxxxxxxxxx'localhost' IDENTIFIED
BY 'password';

but I get a 40032 error

1. A discrepancy between a computed, observed, or measured
	value or condition and the true, specified, or theoretically
	correct value or condition.

	2. <programming> A mental mistake made by a programmer that
	may result in a program {fault}.

	3. (verb) What a program does when it stops as result of a
	programming error.

	(2000-03-28)

From: Captain Paralytic

Date: Monday, July 30, 2007

wrote in message

In {object-oriented programming} sending a message to an
	{object} (to invoke a {method}) is equivalent to calling a
	{procedure} in traditional programming languages, except that
	the actual code executed may only be selected at run time
	depending on the {class} of the object.  Thus, in response to
	the message "drawSelf", the method code invoked would be
	different if the target object were a circle or a square.

	(1995-02-16)

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'@xxxxxxxxxxx'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?

From: Good Man

Date: Wednesday, August 01, 2007

wrote in message in

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'@xxxxxxxxxxx'localhost'
IDENTIFIED BY 'password';
but I get a 40032 error

you have not specified a database

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

Next Message: Update Subquery Help

Blogs related to Unable to create an additional user

Traducere phpBB 3 :: RE: Repartizare fisiere
The board administrator may also grant additional permissions to registered users. Before you login please ensure you are familiar with our terms of use and related policies. Please ensure you read any forum rules as you navigate around ...