I am here in the docs.
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[C
At 11:19 -0500 4/22/05, Scott Purcell wrote:
I am here in the docs.
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NTIFIED BY
'password';
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Andre Matos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 4:26 PM
To: mysql@lists.mysql.com
Subject: Grant question
Hi list,
I have many databases
Hi list,
I have many databases on my MySQL server such as:
dbexample
dbexample_clients_abc
dbexample_clients_def
dbexample_clients_ghi
dbexample_local_abc
dbexample_local_def
dbexample_local_ghi
Is it possible to grant all these databases in just one GRANT instruction
such as:
GRANT SELECT,INSE
At 9:31 + 2/23/04, [EMAIL PROTECTED] wrote:
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
I am new to most aspects of MySQL administration so I was wondering
if someone can help me figure out what GRANTs I need for a
particular situation.
I have a user who needs to be able to r
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
> I am new to most aspects of MySQL administration so I was wondering
> if someone can help me figure out what GRANTs I need for a
> particular situation.
>
> I have a user who needs to be able to run some MySQL scripts that
> create
At 14:56 -0500 2/21/04, Rhino wrote:
Thanks, that clears things up pretty well.
By the way, since you're on the documentation team, can you tell me what the
"official channels" are for making suggestions about the documentation. I
have some ideas about how to make it better
Mail to [EMAIL PROT
Thanks, that clears things up pretty well.
By the way, since you're on the documentation team, can you tell me what the
"official channels" are for making suggestions about the documentation. I
have some ideas about how to make it better
Rhino
--
MySQL General Mailing List
For list archiv
At 14:30 -0500 2/21/04, Rhino wrote:
More followups below
> >> > 1. Why is this happening? The Load Data article says he needs the
File
>privilege and I've given it to him. He also has all privileges on the NFL
>database. What more do I need to do for him?
>>
>> FILE is a global level
More followups below
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 1:25 PM
Subject: Re: GRANT question
> At 13:09 -0500 2/21/04, Rhino
At 13:09 -0500 2/21/04, Rhino wrote:
Followup questions interspersed below
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 12:29 PM
Subject: Re: GRANT question
"Rhino" <[EMAI
Followup questions interspersed below
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 12:29 PM
Subject: Re: GRANT question
> "Rhino" <[EMAIL PROTECTED]> wro
"Rhino" <[EMAIL PROTECTED]> wrote:
> I am new to most aspects of MySQL administration so I was wondering if someone can
> help me figure out what GRANTs I need for a particular situation.
>
> I have a user who needs to be able to run some MySQL scripts that create and load
> tables in a database
I am new to most aspects of MySQL administration so I was wondering if
someone can help me figure out what GRANTs I need for a
particular situation.
I have a user who needs to be able to run some MySQL scripts that
create and load tables in a database named NFL. He is accessing MySQL remote
Hi,
Yes, you're right. GRANT and REVOKE do not need FLUSH PRIVILEGES afterwards.
Flushing is only needed when manually updating the grant tables via normal
INSERT/UPDATE/DELETE commands.
Regards,
Iikka
On Wed, 2 Oct 2002 [EMAIL PROTECTED] wrote:
> If i use GRANT and REVOKE to change user privi
If i use GRANT and REVOKE to change user privileges, it is my understanding
that i don't have
to issue a FLUSH PRIVILEGES statement.
Is this correct?
Our sysadmin rebooted the MySQL server this morning, and there were some
privilege problems
afterward. I had to reset the privileges for some mysql
Another grant command for the existing privileges + index privs. should work
Bhavin.
- Original Message -
From: "Paul Maine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 24, 2002 5:33 PM
Subject: RE: Grant question
> I have an existing mysq
Pada Wed, 24 Jul 2002 18:52:44 -0500
"Paul Maine" <[EMAIL PROTECTED]> menulis :
> I have an existing mysql user that I wish to add the INDEX privilege. Is
> there a command that I can use to add a privilege without first deleting the
> user and then recreating with the GRANT command?
you can run
: Wednesday, July 24, 2002 6:27 PM
To: Paul Maine
Subject: Re: Grant question
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this
I have an existing mysql user that I wish to add the INDEX privilege. Is
there a command that I can use to add a privilege without first deleting the
user and then recreating with the GRANT command?
Thank You
-
Before posting,
20 matches
Mail list logo