Is this an error in Mysql?
I do the follwing command from a shell
grant insert on mydb.* to username@localhost identified by user
'pwd';
When I check the permissions the insert_priv field on user table of mysql db
is set to 'N'.
Why is that? I can change the privileges by giving an
At 9:52 -0700 9/24/02, Nestor Florez wrote:
Is this an error in Mysql?
I do the follwing command from a shell
grant insert on mydb.* to username@localhost identified by user
'pwd';
When I check the permissions the insert_priv field on user table of mysql db
is set to 'N'.
Why is that?
Is this an error in Mysql?
I do the follwing command from a shell
grant insert on mydb.* to username@localhost identified by user
'pwd';
When I check the permissions the insert_priv field on user table of
mysql db is set to 'N'.
This always gave me a lot of confusion at first. If
Independent table permissions are stored in the 'db' table. Base user permissions are
stored in the 'user' table.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 12:52 PM
To: [EMAIL PROTECTED]
Subject: granting does not give
Is this an error in Mysql?
I do the follwing command from a shell
grant insert on mydb.* to username@localhost identified by user
'pwd';
When I check the permissions the insert_priv field on user table of mysql
db
is set to 'N'.
Why is that? I can change the privileges by giving